ForeColor if Null

[jversiz via AccessMonster.com]

Hello Smart People!

This one is driving me nuts. After doing quite a bit of research, I cannot
find the answer that I need, so I am posting...

For a new record on frm1 I am trying to make the label (lblTest) for a text
box named txtTest a certain color if a value has not been filled in. For
some reason, I cannot get the code to work and I am guessing it is due to my
lack of understanding of our good old friend NULL. Here is what in both the
after update event for txtTest and the on current event for the form...

If Me.txtTest = Null Then
Me.lblTest.ForeColor = 255
Me.lblTest.FontBold = True
Else
Me.lblTest.ForeColor = 0
Me.lblTest.FontBold = False
End If

Why isn't the field red when I create a new record? Why is it that if I fill
something into the field, then delete it, that it doesn't get bolded in red?

Regards,
James C.

 

[NetworkTrade]

try

If IsNull(Me.txtTest) Then

 

[jversiz via AccessMonster.com]

Worked great. Thanks for the help!

James C.

try

If IsNull(Me.txtTest) Then

Hello Smart People!

[quoted text clipped - 20 lines]

Regards,
James C.

 

[Linq Adams via AccessMonster.com]

The thing to remember is that NULL is not a value, it's a condition. A
condition, in fact, that signifies ***the lack of a value*** and so nothing
can be equal to NULL!!