Changing the Back Color

[businessman]

I have a CONTINUOUS form that shows all my records. I want it to change the back color of a field when it is a certain value. so far i get it to change back color when the very first record in the list is a certain value, but then it will change the back color for every value and not just one value.

can i fix this?

 

[pbaldy]

If you have version 2000 or later, the simplest way is Conditional Formatting.

 

[businessman]

how would you set up the conditional formatting. do you mean just using if statements in VBA or something else?

 

[pbaldy]

No, it's a built-in feature described in Help. In design view, click on the textbox you want to format, then select Format/Conditional Formatting

 

[businessman]

is there a way to do conditioinal formatting based on one field value and have it affect all the fields for that record?

 

[pbaldy]

Yes, by using "Expression is" instead of "Field Value is". You can highlight multiple controls and set their Conditional Formatting all at once. Your expression might be:

[Quantity] > 10

or whatever. Be careful because if you just type in a field name, the stupid thing will put quotes around it, and it won't work. Thus the brackets.

 

[businessman]

well its not a numberical expression. The field value is "Hold", if it is "Hold" i want the name and status and other fields to be highlighted. I tried typing in Hold with and without quotes and it didn't change the format. perhaps what you meant. is expression only a mathmatical expression?

 

[pbaldy]

No, it should work with an expression like:

[FieldName]="Hold"

Make sure there isn't a control with the same name as the data field, as that will sometimes confuse Access.