Solved

Report formatting not saving

Posted on 2002-07-02
6
257 Views
Last Modified: 2012-05-12
I can't get Access 2K to save changes to the report formatting, including orientation and/or margins.  Anyone have an answer?
0
Comment
Question by:rtstannard
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 28

Expert Comment

by:TextReport
ID: 7125984
When you change the printer setup are you in design mode of the report, if not then the changes do not get saved. If you are in design mode and all you have changed is the print settings then again the changes do not get saved, you must trigger the save yourself using the Save Button of File Save option.

Cheers, Andrew
0
 

Author Comment

by:rtstannard
ID: 7125990
Nope.  Sorry.  The settings work for a bit, then revert to defaults.  I just found the answer on MS KB.  Apparently there is a bug having to do with AutoCorrect.  Turn it off and the report settings will save.

Thanks for the effort, though.

Rick
0
 
LVL 2

Accepted Solution

by:
TT2 earned 100 total points
ID: 7126439
Here is my answer to an identical question which was accepted as an answer a couple of months ago, try it for yourself if you think it will help...

----------------------------------------------------
"I had a similar problem when using Access 2000 when distributing an "mde" front-end database file running under Access 2000 runtime.

When I wanted to specify which tray on the default printer paper was to be taken from, I initially changed the settings in the Page Setup for the particular report and then saved it.  This did work on the development PC for a time (running under the full version of Access 2000) but when I created a new "mde" file and ran it under the runtime version of Access, on a user's PC, it lost the setting immediately.

I spent the best part of a day looking on every Access site I could find, including the page quoted by Nic;o) and was just about to fork-out for the "On The Fly Printing" module listed there. However, for some reason I decided to save the report one final time after making the changes to Page Setup on the report in Design View but this time I held-down the "Ctrl" key on the keyboard whilst clicking on the "Save" button (this can be used with forms in Design View to save the position and size of a form).

To my surprise, the settings retained, not only when the report was printed from the development PC but it was also successful when run under Access Runtime from an "mde" file on the users' PCs.  The application has now been running for a month or so and the report has always retained the settings for the correct paper source tray.

NB Whilst developing the application I set my default printer to the same model as that being used by the users of the system, just to ensure compatibility  - don't know whether this contributed in any way towards overcoming the problem.
----------------------------------------------
I hope this will be of some assistance to you.

TT2
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 54

Expert Comment

by:nico5038
ID: 7126574
You can save the page settings, but the only 100% way is to use the coding from:
http://www.mvps.org/access/reports/rpt0009.htm

Bit more complex...
BTW in the XP version this seems to be solved.

Nic;o)
0
 

Author Comment

by:rtstannard
ID: 7126592
TT2:
This seems to work.  Don't know why.  Don't care, either.  As long as it works.

Nico:
Thanks.  I will probably go get the 'on-the-fly' bits, too.

Rick
0
 
LVL 2

Expert Comment

by:TT2
ID: 7126613
Rick

It surprised me originally as much as it it did you.  It was borne out of desparation and stubbornness.  However, it does seem to be a practical workaround.

I'm pleased it has been of use... Thanks for the points

TT2
0

Featured Post

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question