Is there a test for an empty string that returns a boolean?
You might look at IsMissing, however with your optional string I'd do it
like this
Private Sub SetOptBut(FontBack As Boolean, PlnCptn As String, _
Optional ElevCptn As String = "dummy")
bMissing = (ElevCptn = "dummy")
change "dummy" to something you know will never be passed
Regards,
Peter T
"Dave F." wrote in message
...
Hi
I'm passing the ElevCptn parameter as Optional:
Private Sub SetOptBut(FontBack As Boolean, PlnCptn As String, Optional
ElevCptn As String)
I want to test to see if the parameter has been included & Enable a
button if it is, & Disable it if is isn't, so I'd like it to return a
boolean.
Something like this:
CboElevation.Enabled = IsEmpty(ElevCptn)
Except that doesn't work because "" isn't an empty string.
Any help is appreciated
Ta
Dave F.
|