change font color

[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

 

[Ken Snell \(MVP\)]

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