If Me.txtstatus Like "SP" Then Me.txtlbl1.Visible = True (1 Viewer)

[mrrayj60]

Hey All, need a little help with one.

Using this in the On Open of my form.

If Me.txtstatus Like "SP" Then Me.txtlbl1.Visible = True

But the SP in the record status is sometimes preceded by PO-SP or LI-SP

My code only works if the SP is the leading characters SP-PO.

I've looked thru the wildcards but I end with errors when opened.

Thanks for your help and time.
Rayj

 

[John Big Booty]

Try;

If Me.txtstatus Like "*SP*" Then 
     Me.txtlbl1.Visible = True
Else
     Me.txtlbl1.Visible = False
End If

 

[boblarson]

You can use:

If Me.txtstatus Like "*SP*" Then Me.txtlbl1.Visible = True

Or you could use

If Instr(1, Me.txtstatus, "SP")> 0 Then Me.txtlbl1.Visible = True

 

[mrrayj60]

* inside the quotes, Works like a charm...Thanks Bob & John, It's been awhile since I needed you guys last, the program is handling 2800 homes in a Homeowner Association and till now handling most everything with ease. Thanks Again, Ray