Continuous Form Question

[beb]

I have a continuous form that lists items on a Sales
Quote. The users would like every other line to be gray-
scaled so that it is easier to follow across the form. I
do this in the printed report by using a little VBA
program in the "On Format" event that switches the
BackColor for every other line, but no such event exists
in the form.

Any help anyone can give me would be most appreciated!

 

[PC Datasheet]

If you are using Access2000 or up, look at conditional formatting in the
Help file.

 

[Sandra Daigle]

You can do this using Conditional Formatting (Access 2000 or later). Stephen
Lebans has an example mdb that demonstrates how to do this:

http://www.lebans.com/conditionalformatting.htm