Report Null Value

S

Stu Campbell

I have a report called Date that has a field called SOW Date. In some cases
the SOW Date is blank as information has yet to be turned in. I would like
to change the background color on a null value to red. I have tried to do
this in conditional formatting but doesn't work. How do I do this in VBE?
 
A

Allen Browne

Use conditional formatting.

Choose:
Expression ... [YourFieldNameHere] Is Null
 
S

Stu Campbell

Thank You
--
SAC


Allen Browne said:
Use conditional formatting.

Choose:
Expression ... [YourFieldNameHere] Is Null

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

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

Stu Campbell said:
I have a report called Date that has a field called SOW Date. In some
cases
the SOW Date is blank as information has yet to be turned in. I would
like
to change the background color on a null value to red. I have tried to do
this in conditional formatting but doesn't work. How do I do this in VBE?
Click to expand...
Click to expand...
 
J

jahoobob

Try placing a second control with the same source (SOW Date) behind a
transparent data entry control with the source. Place the conditional
fromatting on the back one to if Field value Is greater than "" and set
the font color to 0 in the properties and the background color to the
desired color (same as other fields) for a non-null value.
Hope this helps,
Bob
 
Top