Page width

[Matt_eu]

Hi everyone,



Can I set the page size to any size? I've been searching the solution all day. According to "Access specifications" the maximum width of form or report is 22 in. (55.87 cm), but I need more than 65 cm width. I guess VBA programming will be the best solution but I don't really know that.

Thank you in advance,
Matt

[ssanfu]

Welcome to the forum.

According to Access specifications, as you saw, the max Form/Report width is 22.75 in (57.79 cm). You cannot use VBA programming to set the form/page width any wider. Time for Plan "B".......

[CJ_London]

max width is based on the the maximum number of twips which is the maximum integer value of 32767. There are 1440 twips to an inch, and approx 567 twips to a centimetre.

1440 as a number works well inches fractions - 1/4 inch=360 twips , 1/10=144 etc. It's a US product, so inches it is.

Agree with Steve, you need to go to plan B - perhaps reduce font and control size?

[Matt_eu]

Oh, such a bad news. Thank you very much for the quick response. I want to place an image to the paper so its size is fixed. So I'm sure to go to plan B.