Conditional Formatting. 1

[Ed2020]

Hi all,

I need to create a subform, which will be displayed in datasheet view, and apply conditional formatting to each row based upon the value in a single column.

So far, no problems at all, however I have eight separate conditions and Access 2003 only allows up to three.

Placing code behind the subform to evaluate the condition and format the controls works fine until I display for form in datasheet view, and then it doesn't work anymore.

Could anyone point me in the right direction with this please?

Many thanks,

Ed Metcalfe.

Please do not feed the trolls.....

 

[PHV]

Have a look here:

http://msdn.microsoft.com/en-us/library/aa139965(office.10).aspx

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

 

[Ed2020]

Thank you PHV, that looks promising.

Ed Metcalfe.

Please do not feed the trolls.....

 

[MajP]

Ed,
You can extend the conditional formatting through code, but in a continous form or datasheet view you can not get more than three at a time. I think you would have to go with something like a flexgrid or listview if that is what you want.