Adding Format condition with code

[Roy Goldhammer]

Hello there

I have huge database that i would like to add to each textbox or combo box
format condion:

If the control is on focus its back color becomes yello

How can i add this condition to each control on my form with code?

 

[Stephen Lebans]

See:
http://support.microsoft.com/default.aspx?scid=kb;en-us;304104
How to programmatically apply conditional formatting settings to all
form controls

For other samples of programmatically manipulating the FormatConditions
object see:
http://www.lebans.com/conditionalformatting.htm
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.