Case Select - empty string 1

[TimTDP]

In a Case select I need to reference a test expression = ""
For example:
Case strReportReference = ""

If strReportReference = "", the case function does not run the code immediatley under it, but goes to the next Case ... line


What is the correct syntax to trap "" ?


strReportReference is dimensioned as a string

 

[RoyVidar]

If this is a variable of datatype string, then

[tt]select case strReportReference
case ""
msgbox "zls"
case else
msgbox "dunno"
end select[/tt]

If it is a variant, or a form control, then it might perhaps be Null, which I don't think you'll be able to trap like that. Then in stead for instance

[tt]if trim$(strReportReference & "") = "" then
msgbox "either zls, Null or containing only spaces"
end if[/tt]

Roy-Vidar