change font color

  • Thread starter Thread starter fishqqq
  • Start date Start date
F

fishqqq

Is there a way to create a macro that would change the font color of a
field from one color to another - but only in that field and only in
that record?

ie I have a macro that duplicates a record.
in the new record i would like the [sellrate] field to be red font -
which would flag the user to confirm the new sell rate for the new
record. then i would create another macro that would change it back to
the original color once the user double clicks the field.

is this possible?

tks
Steve
 
Check out the SetValue action for macro. That also allows you to set a
property for a control.
 

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

Similar Threads

color coding values 1
Access How to record date/time when specific field is modified in Access 2007 0
Plz Help! Create table when submit form 0
VBA to select font/colour not working 1
Conditional Formating for each Record 1
Change the font color/background of a text box depending on value 6
Remove Hyperlinks Without Changing background shading 14
Access Automatically Send a notification email once a record is added 0

Back
Top