Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access reports

ResolvedVersion 2002/XP

Rebecca has attended:
Access Introduction course
Access Intermediate course
Excel VBA Intro Intermediate course

Access Reports

I am just building a basic employee addresses report in access but was wondering if there is a way to get the report to automatically fit each field on the page without shrinking it manually? Currently it goes off the page and I can't seem to get it to fit.
Thanks

RE: Access Reports

Dear Rebecca

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.

One of the possible solutions could be to create multiple column report and that should be able to resolve the problem.


It is quite straight forward.

You simply create a Report via Report Wizard

Choose File > Page Set UP

Click on the Columns Tab and choose 2 or 3 in the No. of Column section.

Change the Height and width of the columns.

Please refer to the following link to create a multi column reports step by step:

http://office.microsoft.com/en-us/access/HA011565341033.aspx

You will notice that towards the end of the article in the section called Download the sample database you can download the sample file that allows you to see how multi column reports look like!

I am trying to upload the same database file but am not sure if I will be able to successfully upload it. If I can't then the best thing is to download it yourself from the website.


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Attached files...

Multiple column reports.mdb

Tue 24 Mar 2009: Automatically marked as resolved.

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.