Conditional Formatting

[Linda RQ]

H Everyone,

I have been playing around with conditional formatting. I Have a few text
boxes with shading if certain items are entered. Now I want the first 3
fields in my subforms to be shaded if a record is started. I can get the
shading to work but I have the next record showing below the current record
that is entered. Those fields are also shaded, I only want them to shade if
there is anything entered in any of those 3 fields. Is there a wild card to
use so if anything is entered so the other 3 fields will shade?

Thanks,
Linda

 

[Steve Schapel]

Linda,

I am not 100% sure I understand what you want. My interpretation is
that you want to set the Conditional Formatting of 2 controls on your
form, to apply if there is any data entered into any of the 3 controls.
If so, I think you can enter into the 'Expresion is...' box, the
equivalent of this:
[Field1] Is Not Null Or [Field2] Is Not Null Or [Field3] Is Not Null