Conditional Formatting Question - blank field

[jmuirman]

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

 

[Allen Browne]

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

 

[Klatuu]

What are you putting in the boxes in the conditional formatter?
It probably is just a syntax problem.

 

[jmuirman]

Ahhh...Thanks! I forgot the field name.

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.

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

 

[SnooziSuzi]

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

Ahhh...Thanks! I forgot the field name.

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.

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