Highlight/Shade everyone other ID in Tabular Form

B

BlueWolverine

Hello,
Running MS Access 2003 on XP Pro.

I have a search results form that lists data tabularly.
There is a lot of redundant data, but it boils down to a list that looks
like this.

1
1
1
1
2
2
2
2
3
3
3

in the ID field. I would like to shade every other number. Maybe make the
first ID number yellow background and the next one white, the next one yellow.

Because it's a search results, the numbers could be anything in any order
and each number may have vastly different number of occurences.

How can one do this? Is it possible without VBA?

Thank you.
 

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