Macro to change font color

  • Thread starter Thread starter kent Dixon
  • Start date Start date
K

kent Dixon

Hello, Is there a macro that I can link to a control that
will change the font color of a cell on a form? Thank you.
Kent
 
Kent,

You can use a SetValue macro action for this. Depends when you want to
change it, but the macro will be a bit like this...
Action: SetValue
Item: [YourControlName].[ForeColor]
Expression: 255
(makes the font color of YourControlName red)
 
Can't you just write a simplpe argument in conditional formatting to take care of suck issues?
 
Back
Top