Expand the maximum Form width
Recently I got a new monitor with a resolution of 3440 x 1440. I wanted to create a Form that uses the entire Screen width. I failed because the Specifications only allows a width of 57,79 cm (which in this case corresponds to about 2200 pixels). This was completely sufficient for decades but with these screens nowadays…
Large form width desired
As per business development,
we now have hit into 2 access limitations to design this report:.
1- Maximum 22 inch width for a crosstab query results displayed in form.
2- Repeating ITEMS when placed in a continuous form in the detail area of a crosstab query, that uses fixed headings
Look at the very last page of this development
Hopefully Microsoft can view these as legitimate business needs.
Anders Ebro (TheSmileyCoder) commented
I agree. This limitation really needs to be lifted.
Another aspect of this problem is that Access does not recognize values above approx. 56 cm in the DoCmd.MoveSize function. If I want to arrange multiple forms next to each other and want to position the far right 32000 twips from the right I receive the Error Code 2505.
There is a Workaround with Windows API Functions for this constellation but it would be really nice if Access internally would be capable for big screens!
I agree, I have a 4k screen and MS Access will not allow me to make the form more than half of the screens width. (22")
Ben Sacheri commented
In preparation for the future, it would be nice if Microsoft would add support for this.
So ... you don't feel 22" wide is wide enough ?