CODEWITHSUNDEEP
ms-access-2010ms-access-2013
Marchese Il Chihuahua
Marchese Il Chihuahua

Reputation: 1129

Conditional formatting in MS Access

I am trying to write an expression within the conditional formatting module of MSAccess to allow me to format a field/control on a form based on the value of another field coming from the same record. Is it possible? At present I would like the field XXX on on my form to change font colours when the underlying field "OverallObjectivesStatus2" from the table "tblProjectMasterList" has a value of "other"... The expression that I built is:

[tblProjectMasterList]![OverallObjectiveStatus2]="other"

but it doesnt seem to be working. Am I missing something? Thanks,

Upvotes: 0

Views: 135

Answers (1)

E Mett
E Mett

Reputation: 2302

Instead of the name of the table ([tblProjectMasterList]) use the name of the form.

Upvotes: 1

Related Questions