Database problem

I need to make a label visible if a certain word appears in one of the fields in my database. However, the label only becomes visible when I click onto the next record and not when I enter the record itself

I am using the following code and have tried putting it in the data control and under form load.

If blah.Text = "blah" Then blahblah.Visible = True
If blah.Text = "" Then blahblah.Visible = False

Any ideas where I am going wrong.

PS. Do any of you guys have jobs because the same people seem to be on here all the time?

Put a textbox instead and do the following:

set the visible property to true
set the text property to "" (null)
in the control source property enter the following:
iif(field = "text", "whatever you want it to display", "")

field is the field you're comparing against.

I think this should work.

I am not sure if you got the answer that you are looking for but I believe that you need a space in you if statement. if blah.text =
" " then .... NOT if blah.text = "" then ....

Lemmie know if that was the problem.

If you put a space in the quotes then access will be looking for a space.