Page setup keeps going back to default settting

L

lbradley

I have a report that is opened by a command button on a form. The report is
set with it's own page setup (i.e., landscape). When the user pushes the
button on the form to open the report, it opens in default page settings
(i.e., potrait, all margins set at 1"). Any way to get the settings to stay?
 
R

Rick B

Have you tried searching previous posts? This is asked very often (usually
in the report newsgroup).

As posted by "Fred" in November 2002...

----------------------------------
If you are using Access 2000 this is a known bug and is documented in
the Microsoft Knowledgebase article:
Q245021 'List of Fixed Problems in Microsoft Office 2000 Service
Release 1/1a (SR-1/SR-1a)'
And specifically:
Q240826 'Lost Printer Settings when Name AutoCorrect is turned on'


Turn off the Name AutoCorrect feature as a temporary 'fix'.
Then download and install the Service Release 1/1a.

----------------------------------


--
Rick B



lbradley said:
I have a report that is opened by a command button on a form. The report is
set with it's own page setup (i.e., landscape). When the user pushes the
button on the form to open the report, it opens in default page settings
(i.e., potrait, all margins set at 1"). Any way to get the settings to
Click to expand...
stay?
 
L

lbradley

Thank you.

I am going to post this as well but maybe you know the answer - How can I
get the parameters that are entered in a report to also display as part as
the report? For example, the users enter the dates between 1/1/05 to 3/1/05,
how can I get this to print on the report?
 
R

Rick B

Put an unbounnd text box on your report and fill it with the same parameter
you used in your query. For example...


=[Enter Start Date]


--
Rick B



lbradley said:
Thank you.

I am going to post this as well but maybe you know the answer - How can I
get the parameters that are entered in a report to also display as part as
the report? For example, the users enter the dates between 1/1/05 to 3/1/05,
how can I get this to print on the report?
Click to expand...
stay?
 
Top