question

Amir-1400 avatar image
0 Votes"
Amir-1400 asked Amir-1400 answered

The controls location change in form view

Sometimes I design a form in Access and carefully arrange the controls in correct position when I change the view to form view, some controls locations change and overlap each other. I don't know why?


84824-001.png


84805-002.png


office-vba-devoffice-access-dev
001.png (5.4 KiB)
002.png (4.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlbertKallal-4360 avatar image
0 Votes"
AlbertKallal-4360 answered AlbertKallal-4360 edited

One other thing to check?
It is what we call control anchoring.

This feature can be put to good use. So if you anchoring controls say right bottom, then a form can re-size and MOVE the buttons based on form size:

eg:
86486-ridessize1.png

Now, make the form larger, and we get this:

86466-ridessize2.png

I did not change the "resolution", but notice how the controls shifted and moved?

You do this with control anchoring. This option on the ribbon:

86534-image.png

so check the control anchoring. If you used anything but top left, then the control can and will shift when you view the form in "view" mode. As noted, often we WANT this to occur, but of course many a time we do not. So check the control anchoring - that could be the issue here.

Regards,
Albert D. Kallal (Access MVP 2003-2017)
Edmonton, Alberta Canada




ridessize1.png (645.6 KiB)
ridessize2.png (442.5 KiB)
image.png (57.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TvanStiphout avatar image
0 Votes"
TvanStiphout answered

Could be several reasons. Maybe you have a Layout Grid around your controls - see Arrange tab.

I set my gridlines WAY smaller (24 * 24) and remove any Layout Grid that might be there; then I size to grid and align to grid, and that keeps it very stable.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Amir-1400 avatar image
0 Votes"
Amir-1400 answered

Dear Mr.Kallal,

Thanks a lot for your detailed and complete reply. I checked it and it was exactly the reason.

Best Regards

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.