Problem with Conditional formatting

[48Highlander]

I want to change the background color of a text box if the value of another control is null or = "". I have the following expression in the Expression Is box but the color does not change.

nz(txtQBDepositID,"") = ""

txtQBDepositID is a bound control

What am I doing wrong?

Bill J

 

[Remou]

Have you checked that it will change color with something simple, 1=1, for example?

 

[missinglinq]

Conditional Formatting is kind of persnickety; it requires square brackets around control names, like this:

nz([txtQBDepositID],"") = ""

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[randy700]

How about this?

nz([COLOR=red][b][[/b][/color]txtQBDepositID[COLOR=red][b]][/b][/color],"") = ""

Randy