Columns in reports

[fridjhon]

I am trying to get my records in two or three columns.
I am using letter size paper in portrait format, each
record is 2" wide, and contains a picture object.
I have set the page setup to 2 columns, width same as
detail, and column layout as across then down.
When I view the report, I get all the records in one
column down the left of the paper.
What else must I do to get the report to print columns?

Lionel

 

[fredg]

I am trying to get my records in two or three columns.
I am using letter size paper in portrait format, each
record is 2" wide, and contains a picture object.
I have set the page setup to 2 columns, width same as
detail, and column layout as across then down.
When I view the report, I get all the records in one
column down the left of the paper.
What else must I do to get the report to print columns?

Lionel

If the width of the report is really 2" then you have done everything
correctly.
Are you sure the REPORT width is 2".
In Design View, check the width of the report or Page Header against the
top ruler. It should be 2". (I'm not talking about the width of the
controls in the detail section, but the actual width of the report.

Alternatively, uncheck the 'Same as Detail' box, and write 2" in the
column width.
Does that make any difference?

What happens if you remove the Picture Object?
Does it print 2 columns now?

If you are using Access 2000...
Another thing to consider. There is a known bug that resets the page
setup settings to their default settings, which is 1 column and 1"
margins.

This bug is documented in the Microsoft Knowledgebase article:
Q245021 'List of Fixed Problems in Microsoft Office 2000 Service
Release 1/1a (SR-1/SR-1a)'
And specifically:
Q240826 'Lost Printer Settings when Name Autocorrect is turned on'

Turn off the Name AutoCorrect feature as a temporary 'fix'.
Then download and install the Service Release 1/1a.