Link to home
Start Free TrialLog in
Avatar of advlegals
advlegals

asked on

MS Access - Forms - Conditional Formatting Based Upon Header Field Value

Conditional formatting:

I'd like to format cells in a tabular form based upon the value in a header field. I've reviewed the conditional formatting dialog and it appears that I can only format a cell based upon its contents.

Is there a way for me to format tabular form fields based upon a value in a header field?

Thanks
Avatar of OnALearningCurve
OnALearningCurve

Hi advlegals,

I am not sure that this is possible.  

If you format a field in a Tabular it will format All the entries in the column iun the same way, not each field individually.

Sorry,

Mark
Avatar of advlegals

ASKER

Hi OnALearningCurve.

That's fine. I do want all fields within the tabular form to be formatted based upon the value in a header field.

The scenario is this:

If my header field reads Sat or Sun then my tabular field background color will be yellow.

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Sorry!  

I have to learn to read questions!!