Reset Position of Controls in Design View

[ItsRoland]

I have a lot of controls in forms that move around dynamically depending on a few different things (specifically talking about the '.Top' property). Some of these forms will reset the position of the controls to their original position when moving to design view, but some don't, which causes a lot of controls to overlap. This means I need to fix the position of all my controls when I enter design view if I want to make changes.



I can't figure out what the difference is between the forms that reset the position of controls and the ones that do not. I tried putting code in the On_Close and On_Unload events to reset the positions, but this gives me the error "object either does not exist or isn't open" no matter which event I used.

How do I ensure the controls will reset back to their original positions when in design view?

Any help is appreciated!

[Minty]

It's generally considered poor practice to actually move controls in a form, and unless you are using

DoCmd.Save

Somewhere those form changes shouldn't be saved. If this was being run in runtime or a compiled accde, it would crash.

It's far more normal to hide and unhide controls as you need them, they can overlap when hidden and it doesn't matter.
If you have too many controls to fit on a normal sized form consider using tabbed pages on one form.

[ItsRoland]

The controls are being hidden when they are overlapping in form view. There are no issues with the form when in form view.

Controls will become hidden if there isn't a value to give them, and the controls underneath are moved up. This causes overlap, which, as you stated, doesn't matter because the controls underneath are hidden. However, when I enter design view, the controls don't go back to their original position and thus the overlap remains. This only happens on some of my forms, not all of them, and in the past has inexplicably stopped happening. I can't figure out what causes the buttons to hold the position they get in form view when in design view.


'DoCmd.Save' appears nowhere in any of my code, so that's not the issue.

I'm not moving controls around due to lack of space, I'm moving them around to keep things dynamic, that way there isn't a large empty space between controls where the hidden one's are.


My apologies for the confusion.

[June7]

I do this but do not encounter the issue. Controls are always in their original position.

I disable the X close and use command button to close all forms.

DoCmd.Close acForm, Me.Name, acSaveNo

However, I think acSaveNo is default.

[ItsRoland]

Whats weird is this has never happened for me either. It only started occurring recently, and in a few cases it stopped happening on its own. I imagine this is why I couldn't find anything about it during my search.

[June7]

Maybe decompile then recompile db. That has fixed some weird behavior for me.