Anchoring controls on a form reset on reopen

[bayners123]

I'm trying to get a subform to expand with its parent form, along with some other textboxes. I've been using the vertical / horizontal anchoring properties to do this and it works exactly how I want IF I make the settings in layout mode.

However, if I make the changes in design mode and then switch to layout/form mode OR if I save, close and reopen the form then the anchoring settings have reset back to top/left.

It's very frustrating because I'm pretty sure I've done the right thing as it all works fine until I save and reopen. Has anyone else experienced this and does anyone know of a solution?

Thanks, I'm posting here for the first time because I've googled for hours to no avail!

[Ruegen]

Maybe? When you close the form

use AcCloseSave

docmd.close ,"yourformname" AcCloseSave

[bayners123]

Maybe? When you close the form

use AcCloseSave

docmd.close ,"yourformname" AcCloseSave

Thanks for the suggestion Ruegen, I'll give it a try. Surely that's just the same as closing it from the GUI though isn't it?

[Ruegen]

I believe it saves the form in its state - where when close it normally - it does not.

[bayners123]

Hmm nope doesn't seem to make any difference I'm afraid. I tried putting DoCmd.Save into the form_close event, saving manually before I quit but still it loads up without the anchoring settings.

[Ruegen]

did you add the line acSaveYes?

[ItsMe]

I don't use Layout view but....

Have you considered the Can Grow properties of the SubForm Control as well as the Form Object that is the Control Source of the Subform Container?

[Ruegen]

I don't use Layout view but....

Have you considered the Can Grow properties of the SubForm Control as well as the Form Object that is the Control Source of the Subform Container?

blinks* rubs eyes* I thought they were for reports only?

[ItsMe]

I still design based on a set screen resolution so I do not really know. I just saw the property available in the subform...