Andrew said:
Is ther any way to get a color chart for conditional
formatting that has more of a selection, or were you can
defind your own color?
Unfortunately, no unless you can reverse engineer the following code:
ConditionalFormat = Begin
0x0100000066000000010000000000000002000000000000000200000001010101 ,
0xff000000ffffff00000000000000000000000000000000000000000000000000 ,
0x0000000000000000000000000000000000000000000000000000000000000000 ,
0x310000000000
End
Watch out for newsreader line breaks.
The code above reads a combo box looking for a value of 1 in the bound
column, and if it's found, make it red, bold, and underlined. The Red, in
Hex code looks like it occurs on the second line, third and fourth
characters (red is 255, the hex code for which is ff). Get the following
code from my website:
http://www.datastrat.com/Code/DocDatabase.txt
to save your form as a text file. This does the whole database. so you'll
have to disassemble it and just work on the form you want. (Are we having
fun yet?)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access