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" wrote:

Ahhh...Thanks! I forgot the field name.
"Allen Browne" wrote:

Try:
Expression [MyField] Is Null
replacing "MyField" with the name of your control.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jmuirman" wrote in message
...
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