List View - Alternating Colours In Rows

[ProjectExplorer]

I am using a List View object and want to make it look like a ledger account - i.e. with alternating colours in each row (vbYellow, vbWhite, vbYellow, vbWhite etc.).

Does any one know if this is possible?

Any help appreciated.

Thanks

 

[SkipVought]

Hi,

No need for VBA.

Use Conditional Formatting, using the MOD function to catch odd or even rows.

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[ProjectExplorer]

Thanks for your suggestion SkipThought.

However, Conditional Formatting isn't available to the List View Control (at least not in my developer version of Access).

 

[PHV]

Have a look here:
faq702-6027

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

You ought to be posting in one of the Access forums like Forum705

I wrongly assumed that you were in Excel.

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}