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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Formatting for Null Field 1

Status
Not open for further replies.

Elvis72

Technical User
Dec 6, 2007
211
US
I need to have the whole record on a report highlighted in Red if the Last Name field is null.

I understand the Conditional Formatting tool in reference to dates and numbers, but not text?

Any help is GREATLY appreciated!~
 
You should be able to use Expression Is.


Expression Is: txtText Is Null
 
Well, I did this:

Expression Is: [last name] is null

And I what I get is ALL the last names end up red?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top