Conditional Formatting Question - blank field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to have a field in a report become red if the field is blank. I can't
seem to use conditional formatting for this.

Thanks,

John
 
Try:
Expression [MyField] Is Null
replacing "MyField" with the name of your control.
 
What are you putting in the boxes in the conditional formatter?
It probably is just a syntax problem.
 
Ahhh...Thanks! I forgot the field name.
Allen Browne said:
Try:
Expression [MyField] Is Null
replacing "MyField" with the name of your control.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

jmuirman said:
I want to have a field in a report become red if the field is blank. I
can't
seem to use conditional formatting for this.

Thanks,

John
Click to expand...
Click to expand...
 
Hi, I am also having this problem and have followed the steps above but it
is still not displaying a shaded field on my report.

I have highlighted the field, clicked conditional formatting, dropped down
to 'Expression is' typed "JobTitle" is null, set the outcome (ie a shaded
feild) but when I run the report the blank fields are still empty!! (have
also tried with the square brackets in, in case that was my problem).

I have checked that they are set to Can Grow 'NO' and that the font colour
is black so that it would show up....

what else can I do!?

I am using Access 2007.

Thanks very much,
--
Snoozi Suzi


jmuirman said:
Ahhh...Thanks! I forgot the field name.
Allen Browne said:
Try:
Expression [MyField] Is Null
replacing "MyField" with the name of your control.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

jmuirman said:
I want to have a field in a report become red if the field is blank. I
can't
seem to use conditional formatting for this.

Thanks,

John
Click to expand...
Click to expand...
Click to expand...
 
Back
Top