Saving Changes to a Control's Properties

[bobleonard]

Hi,
I'm making some changes to a control's properties. I do this in the Detail.Format event. The changes work fine but I would like to save them.

I've tried:
DoCmd.RunCommand acCmdSave

after I make the changes but this doesn't take.

Also, (from reading posts) I've tried:
DoCmd.Close acForm, "SIIIPrint", acSaveYes
in the Report_Unload event. (there is only one form)
that didn't work.

For any other suggestions, Thanks
BLeonrd

 

[MajP]

In order to persist changes you have to open the form in design view then use the code you show to save the changes.

 

[missinglinq]

As MajP stated, for this kind of change to persist, in a Form, it first has to be opened in Design View, then the changes made, then saved.

But I'm curious as to how you tried this for a Form using the DetailFormat event? This event, at least in versions 200/2003 and 2007, is only available in Reports! Has this changed in 2010?

The Missinglinq

Richmond, Virginia

The Devil's in the Details!