In a grouped report, rather than print into a horizontal row of text boxes for each group, I'm trying to print into a vertical column of text boxes for each group. So instead of printing the "headers" for the text boxes in the page header (i.e., across the page), I want to print the headers in the first column (i.e., down the left side of the page).
The problem is that the headers are wider than the text boxes. So I want the first column (with the headers) to be wider, and subsequent columns (with the text boxes) to be narrower (and all the same size). It appears you cannot "rotate" the page header from a horizontal to a vertical orientation. I tried a "dummy grouping" just above my report grouping. This works but I cannot differentially control the width of the columns--Access allows me to only specify ALL column widths in the Page Setup => Columns window. So it's either all my columns are to wide (so that I can accomodate the wide first column) or my first column is too narrow (to accomodate all the narrow subsequent columns).
Is there a way in VBA to define a different column widths for my "dummy grouping" and for my grouping header?
The problem is that the headers are wider than the text boxes. So I want the first column (with the headers) to be wider, and subsequent columns (with the text boxes) to be narrower (and all the same size). It appears you cannot "rotate" the page header from a horizontal to a vertical orientation. I tried a "dummy grouping" just above my report grouping. This works but I cannot differentially control the width of the columns--Access allows me to only specify ALL column widths in the Page Setup => Columns window. So it's either all my columns are to wide (so that I can accomodate the wide first column) or my first column is too narrow (to accomodate all the narrow subsequent columns).
Is there a way in VBA to define a different column widths for my "dummy grouping" and for my grouping header?
Comment