How do I use VBA to alter a report's
page settings, such as left/right
margins, columns count and width, etc?
Can you clarify why you want to do these Design View functions in VBA Code,
rather than in Design View? The only reason I can imagine is that you want
to create a Wizard to create a Report. If that's not what you are doing, if
you'll tell us what you are trying to accomplish, maybe someone can suggest
an easier way.
Just for the record, I haven't written any Report Wizards, so I'd have to
research those, the same as you would. Access 2003 Help has much improved
content over previous versions and is very good -- if you have a high-speed
Internet connection because it is "online primary." It is a very good
"entrance" into Office Online and MSDN where there is lots of information.
An advanced book that might have what you need (browse it at your local
well-stocked bookstore) is the Access <version#> Developer's Handbook, by
Litwin, Getz, et al, published by Sybex. (There isn't a 2003 edition, but
the 2002 edition will cover Access 2003 just fine.)
Larry Linson
Microsoft Access MVP
