I have set up some simple vba coding on open of my report. It looks like this:
LSCNO.BackColor = IIf (IsNull(COMPLETION_DATE), 1677215, 12632256)
CUSTOMER.BackColor = IIf (IsNull(COMPLETION_DATE), 1677215, 1232256)
I want the 2 fields LSCNO and CUSTOMER to have a white background if the field COMPLETION DATE doesn't have a date, but have a gray background if there is a COMPLETION DATE. With this coding, every job is getting shaded whether there's a COMPLETION DATE or not.

two things:

1. 1677215 is not white, you want 16777215.

2. this code should be in the OnFormat event of the section where LSCNO and customer appear.

hth,
al

Thanks!
It's working now.