Conditional Formating Same Color as Form Background

[Samantha]

Hi,
I got the conditional formatting on a continuous form to work. My only
problem is getting the color of the text box (the one under the conditional
format) to change to match the 'default' color of the background. From my
computer, it appears that the 'default' color is a shade of gray, but I can
not find the exact match.

Is there a way to match the color of the text box (from current white) to
the default of the form? Any pointers are very much appreciated. Thank you.

 

[Rob Parker]

With conditional formatting, you are limited to the colors available in the
drop-down color-picker dialog; you also can't use conditional formatting to
set the BackStyle for the controls to Transparent. About the only thing I
can suggest is that you change the BackColor of the Detail section of your
form to match one of the grey shades available in the color-picker.

HTH,

Rob

 

[Samantha]

Thanks Rob for your prompt response. I just wish that there would be a
simpler way to do this.
Samantha

 

[Marshall Barton]

I got the conditional formatting on a continuous form to work. My only
problem is getting the color of the text box (the one under the conditional
format) to change to match the 'default' color of the background. From my
computer, it appears that the 'default' color is a shade of gray, but I can
not find the exact match.

Is there a way to match the color of the text box (from current white) to
the default of the form? Any pointers are very much appreciated. Thank you.

The system colors are specified using special color codes
that are negative numbers. See System Colors in Help for
details. If you use these special color codes consistently
throughout all of your forms, then your forms will conform
to whatever color scheme your users choose in their Windows
- Display Properties settings.

The easiest way to match something to the form's background
color is to Copy/Paste the color value from the section's
BackColor property.

To specify one of these special color codes for conditional
formatting you need to use code in the form (Open event):

Me.controlname.FormatConditions(N).BackColor = -2147483633

where N is the index (0, 1 or 2) of the CF condition you
want to change.