macros

  • Thread starter Thread starter pizzats
  • Start date Start date
P

pizzats

I'm trying to change the forecolor of a control on a form
using a macro. After I select the forecolor with my
expression builder it does'nt save. I want it to save so
I can select the action SET Value on the Macro page and
set the forecolor of the control to 255. Help Tim
 
Tim,

If the form is open, any change to the properties will only be
applicable to the current session of the form, and will not be saved.
To retain the colour change, the form will need to be in design view. A
macro like this should do what you are asking...

Action: OpenForm
Form Name: (name of your form)
View: Design
Action: SetValue
Item: [Forms]![NameOfYourForm]![NameOfControl].[ForeColor]
Expression: 255
Action: Close
Save: Yes
 
Back
Top