Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access Reports

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access Reports

Resolved · Low Priority · Version 2002/XP

Reply Mon 16 Mar 2009, 16:46Delegate Rebecca said...

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

For upcoming training course dates see: Pricing & availability

Reply Tue 17 Mar 2009, 16:02Trainer Rajeev said...

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 articles

· Access Corruption Avoidance Tip #3: Stay Connected
· How To Filter And Sort Data In Access 2010 Tables
· Learn The Secrets Of Customising An Autonumber Primary Key In Access
· How To Use The New Navigation Form In Access 2010
· Access Corruption Avoidance Tip #1: Split Your Database

Please browse our web site to find out more about
training for microsoft access and other Microsoft training courses.

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips