Controling Backcolor in a continuous form

[vaneujl]

How can I control the backcolor of a field of a continuous form according the value?
It works when this is a single form using the 'on current' event.
It works also in a report using format event.
But using a continuous form, the back color will be the same for all records whatever the value of each record is.

Thanks for your help.

 

[DougP]

Another Foo-Bah for Access
can't be done DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[GBall]

Sorry Doug, you're wrong.
Vaneujl, drop me a line and I'll send you a sample database courtesy of Peter Meachem.

graham.ball@europe.com