Conditional Formatting

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top