How can i change the colour ?

[Guest]

Hi,

I have a continuous form based in a query.I want to change the colour of a
specific field to Red or blue when it has a spesific value.

In the property current of the form I have a procedure which change the
colour but when I focus this field the colour changes in all the column this
field.

What can i do ?

Thanks

 

[Guest]

Nothing you can do. Although you see many occurances of that control
(field), in reality, there is only one. Notice when you veiw the form in
design view, you see it one time, so every one you see in form view is just a
replication of the one. So, any time you change a property for that control,
it affects all occurances of it.

 

[Marshall Barton]

I have a continuous form based in a query.I want to change the colour of a
specific field to Red or blue when it has a spesific value.

In the property current of the form I have a procedure which change the
colour but when I focus this field the colour changes in all the column this
field.

Have you tried to use Conditional Formatting (Format menu)
on the control? If you did, what about it was insufficient?