Form retaining size for certain users

[Perceptus]

Access 2007.



A single user has reported that a form appears in a size that other users see in its normal size. I am not too sure how this occurs, all users use the same front end. There is no special code changing the size of the form. Is there a way that settings could save form size per machine accessing the database?

[John_G]

I'm not sure what you mean by "size" here, but screen resolution settings (which are independant of Access) will affect the amount of space a form takes up on the screen.

[Perceptus]

Width of the form is set to 6". The visible area on most users screens is greater than 20" with a resolution at 1920x1080. For the one user who has the issue the form is appearing with a width of less than 3" with a resolution of 1024x768. When the form appears smaller on the specific users there is clearly enough space for it to appear in full size. But it does not.

[aytee111]

You could set the size of the form in VBA in the OnOpen event - DoCmd.MoveSize xxx. That sets it to an exact size, rather than depending on the screen resolution and/or user settings.

[Perceptus]

I am concerned as to why one user is seeing this issue. A code update would be the quickest kludge, but what if this keeps occuring. I would rather not have to set the twips for each form in code.

[aytee111]

Either that or use tabbed forms. Or set your own resolution to match the smallest allowable value and design your forms with that in mind. That would make it big for the other users, however.