Conditional Formatting

  • Thread starter Thread starter Skip & Regina
  • Start date Start date
S

Skip & Regina

I know this is probably a stupid question, but I want to conditional format
a report field if another field on the report is blank (no data entered). I
have tried if [Field]="" but that does not work. How can I get this to
work?

Thanks,
Skip
 
Try inserting the following formula in the field you want to format,
=IF(ISBLANK(A1),"No data",A1) were A1 is the field which may or may not be
blank. I have assumed that if there is data then this will be in the report
field.

Use Conditional Formatting to set Condition 1 Equal to "No data" and format
as required.

Hope this helps.

JohnH
 
AHHHHHHHHHHHH Sorry Skip, what a jerk, I had my Excel head on, your talking
Access, don't I feel dumb.
please ignore my stupid reply. Sorry.

JohnH
 
Back
Top