Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional formatting if field populated

Status
Not open for further replies.

jh3016

Programmer
Jun 6, 2003
148
US
I have a subform that I need to have conditional formatting. If field is blank, then red background. If field is populated, then leave white.

Thanks in advance.
 
Hi jh3016,

Conditional Formatting > Condition 1 = Expression Is > [blue]IsNull([YourField])[/blue]

Set the formats you want.

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top