Wildcards making form objects visible

[brownlb]

I need to make a few captions and text boxes visible only when there is a *E* in the "Circuit ID" field.

Here's what I've got.

Private Sub Date_Order_Sent_Enter()
If [Circuit ID] = *E* Then <<<<It doesn't like this line
[ISP Vendor].Visible = True
Combo155.Visible = True
Combo157.Visible = True
Label99.Visible = True
Label156.Visible = True
Label158.Visible = True
End If
End Sub

It works great if I hard code a valid Circuit ID where the *E* is. What's the right way to do a wildcard in VBA? I know it's not *. I've tried [E] as well, and it still doesn't work.

 

[TonyJollans]

Hi ,

Try ..

If [Circuit ID]

Like "*E*"

 Then

Enjoy,
Tony

 

[brownlb]

Thanks Tony!

That's exactly what I needed. So simple, but I never would have figured it out!

Blair