Conditional Formatting

[lj]

Is there any way to do conditional formatting in VBA? Or at least see the
property assignments made by the menu item?

I'm wondering because I don't like any of the colors offered by the little
color palette associated with this tool...

lj

 

[Arvin Meyer]

Is there any way to do conditional formatting in VBA? Or at least see the
property assignments made by the menu item?

I'm wondering because I don't like any of the colors offered by the little
color palette associated with this tool...

There is a way, but it is a lot of work. You need to first save the form
definition as text. See my code at:

http://www.datastrat.com/Code/DocDatabase.txt

Then you'll need to open the text document up and find the color conditional
formatting, and change it. You can get a color picker to get the number
required from Stephen Lebans website:

http://www.lebans.com

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access