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