A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Paper size in print setup won't change



 
 
Thread Tools Display Modes
  #1  
Old December 17th, 2004, 05:13 AM
HMN
external usenet poster
 
Posts: n/a
Default Paper size in print setup won't change

I cannot change from letter to legal size to print one particular report.
When I click legal in print setup it doesn't change from letter. Other
reports I have in this computer are no problem-I can change from legal to
letter and back. This report was printing to legal-I don't know what changed
it. Thanks for any help.
--
HMN
  #2  
Old December 17th, 2004, 07:19 AM
Allen Browne
external usenet poster
 
Posts: n/a
Default

This may be another Name AutoCorrect issue. See:
Lost Printer Settings When Name AutoCorrect Is Enabled
at:
http://support.microsoft.com/?id=240826

If so, this should fix it:
1. Uncheck the Name AutoCorrect boxes under:
Tools | Options |General

2. Compact the database:
Tools | Database Utilities | Compact

3. If the report has a module, decompile a copy of the database by entering
something like this at the command prompt while Access is not running. It is
all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Compact again.

5. Select the report in the Database window, copy (ctrl+C) and paste
(Ctrl+V). Once you have established that the copy works you should be able
to delete the original report, compact agian, and then rename the copy back
to the original name.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"HMN" wrote in message
...
I cannot change from letter to legal size to print one particular report.
When I click legal in print setup it doesn't change from letter. Other
reports I have in this computer are no problem-I can change from legal to
letter and back. This report was printing to legal-I don't know what
changed
it. Thanks for any help.
--
HMN



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
User defined paper size for a report David Wren General Discussion 0 November 9th, 2004 02:25 PM
header with legal size paper Francois Houde Formatting Long Documents 1 November 5th, 2004 08:37 PM
I need to be able to set Paper size programatically cafr2000 Setting Up & Running Reports 5 September 27th, 2004 06:17 PM
Printing on 5.5(w)x8.5(l) size paper Craig General Discussion 1 July 1st, 2004 09:29 PM
Creating a larger paper size Scott P Worksheet Functions 3 December 21st, 2003 12:44 AM


All times are GMT +1. The time now is 01:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.