.WindowWidth goes negative when it exceeds 32600

[ljpitre]

MS Access 2013, some of our users now have 30" inch monitors. Therefore with the maximum 22" access control width I have to rework the resize function.
However, when the .WindowWidth exceeds 32600, it goes negative.


can anyone explain this and how to get around it?
thanks

[isladogs]

Some conjecture follows ....

I believe its because the screen dimensions use an integer datatype which has limits -32,768 to 32,767
So when you reach 32767 it goes negative

I believe the maximum form width or section height of 22.75 inches is for the same reason
There are 1440 twips per inch and 22.75*1440 = 32760 which is effectively the integer limit

So to increase those limits, MS would need to do some fundamental structural changes to use long integer instead
If so, the mind boggles on how large the form & report limits would become

That doesn't explain why the maximum height of all sections of a report is 200 inches ...but as always Access works in mysterious ways

[CJ_London]

it is because it is an integer - maximum value 32767. There are 1440 twips per inch, so 32767/1440=22.75 inches. Don't confuse form width with window width. A 10" wide form can be displayed in a 30" wide window - it will be displayed top left of the window with everything to the right taking the back colour of the relevant section. A 20" wide form displayed in a 10" wide window would provide a scrollbar for users to navigate left to right.

The only way round it would be by having two or more forms being managed side by side with VBA. This could be done in the access window (you can hide most things like navigation window/ribbons etc) or by using popup forms.

Edit: Also for postioning controls you should really use insidewidth rather that windowwidth to take account the thickness of the window border and scrollbars