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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Run select query from VBA code where criteria comes from a multi select ListBox 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
printer columns 3
Columns in subreport in main report footer 3
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Multiple Calculations based upon a SQL in Report 3
Cross Tab Report Vs Dynamic coulmns 0

Back
Top