Report formatting not saving

Posted on 2002-07-02
Medium Priority
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?
Question by:rtstannard
LVL 28

Expert Comment

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

Author Comment

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.


Accepted Solution

TT2 earned 400 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.

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

LVL 54

Expert Comment

ID: 7126574
You can save the page settings, but the only 100% way is to use the coding from:

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


Author Comment

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

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


Expert Comment

ID: 7126613

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


Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

621 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