Conditional Formatting - Custom Colors

[Guest]

Requesting assistance/guidance on CF Colors ... A2000 database format running
on A2003 ...

1. Have a desire/need to have CF condition(s) result in both Forms and
Reports output formatted from the Custom Colors Pallete ... The UI seems to
only allow the standard color choices from the drop-down choices box in CF ...

2. If not available from the UI, any suggestions from a coding perspective
would also be welcomed ... Thank you!

 

[Allen Browne]

You can assign other colors programmatically.

1. Choose any color (e.g. solid red).

2. Open the Immediate Window (Ctrl+G.)

3. Enter something like this:
? Forms!Form1!Text0.FormatConditions(0).BackColor
substituting your form and text box names.

4. After verifying the result, assign the value you want, e.g.:
Forms!Form1!Text0.FormatConditions(0).BackColor = RGB(128,128,128)