Access 2007 printing

[Highwayman]

I am trying to create a listing of the personnel in the company. I would like
the final print-out to formatted in three columns with sequential data blocks
the be three sets vertical and three columns horizontal on a single page. I
have the data entered and have been able to get it to print three data blocks
horizontal but not vertical.

Maybe a better explanatoion is that I want no.1 person to be upper left hand
corner and no.2 person to be under no.1. no.3 under no.2, and no.4 will be at
the top of column two.

Any help would be appreciated greatly.

 

[Chuck]

I am trying to create a listing of the personnel in the company. I would like
the final print-out to formatted in three columns with sequential data blocks
the be three sets vertical and three columns horizontal on a single page. I
have the data entered and have been able to get it to print three data blocks
horizontal but not vertical.

Maybe a better explanatoion is that I want no.1 person to be upper left hand
corner and no.2 person to be under no.1. no.3 under no.2, and no.4 will be at
the top of column two.

Any help would be appreciated greatly.

Click on: File/Pagesetup/Columns. Set the columns properties the way you want
them to look. Choose: Down then Over.
Set the detail height as required to alow the three data blocks vertically on a
page. Set can grow to no for everything. If you always want three data blocks
vertically and horizontally then you must have exact hard control of everything
on the page.

 

[Highwayman]

Thanks for the info, but I am puzzeled. I found everything that you mentioned
and it was already set for the size of page that would accommodate the print.
However, I do not understand the comment "set can grow to no for everything."
And I do not understand your comment about exact hard control of everything
on the page.
Thanks again.

 

[Chuck]

Thanks for the info, but I am puzzeled. I found everything that you mentioned
and it was already set for the size of page that would accommodate the print.
However, I do not understand the comment "set can grow to no for everything."
And I do not understand your comment about exact hard control of everything
on the page.
Thanks again.

Every control in a report has its own individual properties. One of those
properties is Can Grow. That value can only be one of two choices, Yes or No.
Make sure that all are set to Can Grow = No. Otherwise the final report will
not all fit on one page.

By hard control I mean do not let anything in the report change in size or
location as a function of the data that is being printed. If the data being
printed will not fit in the location and space allocated in the report design,
change what goes into that space or change the font size until it does fit.

 

[Highwayman]

Where are these properties found?

 

[Highwayman]

O.K. I found the "Can Grow" and it was already set at "NO" per the default. I
am able to get the three columns with a different data block in eadch column,
but I am unable the get the columns to have more than one data block. If I
print two pages, I get 6 blocks of data, one in each column.

 

[Chuck]

O.K. I found the "Can Grow" and it was already set at "NO" per the default. I
am able to get the three columns with a different data block in eadch column,
but I am unable the get the columns to have more than one data block. If I
print two pages, I get 6 blocks of data, one in each column.

Open your report in design mode. Click on File in the top menu bar. Click on
Page Setup in the drop down list under File. Under the Margins tab Set the
Top margin to 0.500 inches. Set Bottom margin to 0.275 inches. Set the Left
margin to 0.253 inches and the Right margin to 0.250 inches. Except for the
top margin these are the minimum settings my printer will accept. Some
printers may not accept such small values. Click on the Columns tab. Set
Number of Columns to 3. Set row Spacing to 0. Set Column Spacing to 0.10
inches. Set Column Size Width = to 2.6597 inches. Set Column Height = 0.
Do not check Column Same as Detail. Set Column Layout to Down then Across.
Click OK. In Report design view Set your Report and Page headers and footers =
0. Set Detail Section Height = 3.4076 inches. Everything you want to go in
your data block must fit within the 2.6597 inch by 3.4076 inch space in order
have a print out with three columns and three data blocks on one page.

 

[Highwayman]

Perfect - I was setting the height too far and telling it that the data was
extending the entire sheet length. Actually I must be using another
version/release, because I do not have a "File" on the top bar. But it all
worked out.

Thanks again

 

[Chuck]

Perfect - I was setting the height too far and telling it that the data was
extending the entire sheet length. Actually I must be using another
version/release, because I do not have a "File" on the top bar. But it all
worked out.

Thanks again

You're welcome.