setting columns in VBA

W

Wm

I want to set the number of columns in VBA based on the maximum size of the
data I'm displaying. Where do I find the "page setup" properties for a
report?

TIA,
William Schmidt
 
A

Allen Browne

The nubmer of columns (ItemsAcross) is part of the PrtMip property.
You need the report open in design view to manipulate this property.

This is not a simple thing to get right, illustrated by the fact that
Microsoft got the Help examples wrong in Access 95, 97, and 2000--and in
different places in those versions! Haven't checked the more recent files,
but I suggest you use the examples from MSDN or this article:
http://www.microsoft.com/AccessDev/Articles/GetzCh10.HTM
 
Top