P
Perplexed
I have a report that I have coded the detail format event with the code that
was posted to make every other line in the detail appear shaded.
If Me.Section(0).BackColor = vbWhite Then
Me.Section(0).BackColor = 12632256 'gray
Else
Me.Section(0).BackColor = vbWhite
End If
It works great!
I then applied conditional formating to a field to appear in red if the year
in the field was less than this year. It worked great also.
My problem is that when I tried to apply conditional formatting to a field
if the field is NULL is working strangely.
I used: 'Expression is' [fieldname] Is Null
and wanted a shaded background to attract attention to the field. It works;
however, it changes the background of the fields with data to white. My
default on the form design was transparent and I can't seem to get it to stay.
Any suggestions? Thanks!
was posted to make every other line in the detail appear shaded.
If Me.Section(0).BackColor = vbWhite Then
Me.Section(0).BackColor = 12632256 'gray
Else
Me.Section(0).BackColor = vbWhite
End If
It works great!
I then applied conditional formating to a field to appear in red if the year
in the field was less than this year. It worked great also.
My problem is that when I tried to apply conditional formatting to a field
if the field is NULL is working strangely.
I used: 'Expression is' [fieldname] Is Null
and wanted a shaded background to attract attention to the field. It works;
however, it changes the background of the fields with data to white. My
default on the form design was transparent and I can't seem to get it to stay.
Any suggestions? Thanks!