setting columns in VBA

  • Thread starter Thread starter Wm
  • Start date Start date
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
 
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
 
Back
Top