Show text box in a form based on a character within a string in another text box

[zdjbel]

Hi,

I have a form where I want a textbox [txtMaxOrdLimit] to be visible only if another text box on the same form [PaNumber] contains the letter D in the string. This is the code I have on the forms On Current property but I'm missing something because textbox [txtMaxOrdLimit] doesn't show on the form at all.

If Me.PaNumber = "*D" Then
Me.txtMaxOrdLimit.Visible = True
Else
Me.txtMaxOrdLimit.Visible = False
End If


Thanks very much.

[pbaldy]

To use a wildcard you need to use Like instead of =. Also, that would only work if D was the last letter. If you want it anywhere in the string: "*D*".

[zdjbel]

To use a wildcard you need to use Like instead of =. Also, that would only work if D was the last letter. If you want it anywhere in the string: "*D*".

Thanks very much, I thought that "Like" could only be used in queries.

[pbaldy]

No problem.