Access 2007-Formatting reports

The UK's most regular instructor-led training courses.
Training information: introduction access training · Access course microsoft training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Deborah has attended:
Access Introduction course

by - delegate Deborah [1 post] (2008 Mar 17 Mon, 16:52) Reply

Can you save the format of a report you run regularly, so when you come to run it again you don't have to reformat it.

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: access 2007-Formatting reports

by - trainer Pete platinum contributer [799 posts] (2008 Mar 27 Thu, 11:15) Reply

Hi Deborah, Thank you for your post, welcome to the forum, in answer to your question, generally when you save a report it will retain the formatting that you applied when you created it. I cannot see this altering unless you were to change to design view and apply a different format style manually. I hope that helps, best regards Pete.

· Access Database Optimization: First Normal Form
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Microsoft Access as a Business's Database Management System
· Why go on a Microsoft Access Training Course?

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

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.