I have a text field AnesNum that ca

[mxp346]

I have a text field AnesNum that can include several ID numbers. If the ID number 111 is include in this set of numbers, I want the text field OtherAnesType to become visible. The following code works if I type in *111* but not if I type in 111 or 111, 123. The help file said that * can be used as a wildcard but it's not working. Any ideas?

Private Sub AnesNum_AfterUpdate()

If AnesNum = "*111*" Then
    OtherAnesType.Visible = True
Else
    OtherAnesType.Visible = False
End If

End Sub

Thanks for the help, Matt

 

[Junior1544]

well, first change i would make is this... put a me. in front of the AnesNum...

Private Sub AnesNum_AfterUpdate()

If me.AnesNum = "*111*" Then
me.OtherAnesType.Visible = True
Else
me.OtherAnesType.Visible = False
End If

End Sub
JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[mxp346]

I added in the Me. but it still only becomes visible if I type *111*. Any other suggestions?

 

[jebry]

Hi!

Use this code:

If Me!AnesNum Like "*111*" Then etc.

One quick question, do you need the wildcards because different numbers will be typed like 111F or G111H2? If the only number that will be typed is 111 then just use If Me!AnesNum = "111".

hth
Jeff Bridgham
bridgham@purdue.edu

 

[mxp346]

Thank you very much jerby, adding the like in there worked. I needed the wildcard because there are different numbers that included 111, things along the line of what you mentioned... 111F or G111H2.