K kent Dixon Apr 26, 2004 #1 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
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
S Steve Schapel Apr 26, 2004 #2 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)
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)
G Guest Apr 27, 2004 #3 Can't you just write a simplpe argument in conditional formatting to take care of suck issues?