Solved

Report formatting not saving

Posted on 2002-07-02
6
250 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

738 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