Multi Column Reports

[Guest]

I have a report that I have successfully hidden the labels on all other columns but the first column, but I don't know how to resize the other columns so they are not too wide. Does anyone know how to do this?

 

[Duane Hookom]

Check this kb article How to Print Labels on the Left Margin of a Report
http://support.microsoft.com/default.aspx?scid=kb;en-us;210044&Product=acc

--
Duane Hookom
MS Access MVP

I have a report that I have successfully hidden the labels on all other

columns but the first column, but I don't know how to resize the other
columns so they are not too wide. Does anyone know how to do this?

 

[Guest]

I can get the labels on the left hand side of the report but I can't change the column widths. Column one needs to be 2 inches to include the labels but columns 2 and on don't need to be 2 inches because they don't have labels. Anyone have any idea how I can change the width of columns 2 and on.

 

[Duane Hookom]

There is a sample multicolumn report mdb at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4 that doesn't use the
Page Setup to create the columns. I expect you could modify the code to get
the required results.

--
Duane Hookom
MS Access MVP

I can get the labels on the left hand side of the report but I can't

change the column widths. Column one needs to be 2 inches to include the
labels but columns 2 and on don't need to be 2 inches because they don't
have labels. Anyone have any idea how I can change the width of columns 2
and on.