How can i change the colour ?

K

Kimon

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
 
K

Klatuu

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.
 
M

Marshall Barton

Kimon said:
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.
Click to expand...


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