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.


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top