visible text box

[Starr M via AccessMonster.com]

How can I make a text box visible using only partial text from a previous
text box

If Me![TEXT] Like "C/O*" Then
Me![Blanktextline].Visible = True
Else
Me![Blanktextline].Visible = False
End If

 

[Rick B]

In which event did you place this code?

That looks like it would work. What is the problem?

 

[Jayyde]

Use

Dim intSubStringLoc As Integer
intSubStringLoc = InStr("My dog has fleas", "dog")

if it's at the very begining it'll return 1, if it doesn't find it
it'll return 0.

 

[Starr M via AccessMonster.com]

the On current of the form - I doesn't work.

In which event did you place this code?

That looks like it would work. What is the problem?

How can I make a text box visible using only partial text from a previous
text box

[quoted text clipped - 4 lines]

Me![Blanktextline].Visible = False
End If

 

[Brian Bastl]

Use the AfterUpdate event of the first text box.

Brian

the On current of the form - I doesn't work.

In which event did you place this code?

That looks like it would work. What is the problem?

How can I make a text box visible using only partial text from a previous
text box

[quoted text clipped - 4 lines]

Me![Blanktextline].Visible = False
End If

 

[Rick B]

That will cause it to fire as you move from one record to another. You also
need to fire it when you change the entry in the text box if you want it to
fire as the user enters a new record or modifies an existing record.

--
Rick B

the On current of the form - I doesn't work.

In which event did you place this code?

That looks like it would work. What is the problem?

How can I make a text box visible using only partial text from a
previous
text box

[quoted text clipped - 4 lines]

Me![Blanktextline].Visible = False
End If