Report Null Value

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

Guest

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?
 
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...
 
Back
Top