troubleshooting Question

how do I set the number of columns in Access 2007 Report via vba

Avatar of Karen Schaefer
Karen SchaeferFlag for United States of America asked on
Microsoft AccessMicrosoft ApplicationsMicrosoft Development
21 Comments1 Solution427 ViewsLast Modified:
I need to determine the number of columns to be used for a report, the number of columns will vary between Managers.  I am attempting to set the column widths, and number of columns to appear on a report (Org Chart) - to prevent multiple pages.

Is there a way to determine the number of columns needed and via code set the number of columns needed and the column width?  Some of my mangers have 9 columns and some may have as many as 11 and I would like to fit it on to one page (11x17 - tabloid).  Also set the margins.

K
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 21 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 21 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros