Typically, Microsoft Access reports have default 'Page Setup' settings, and
every time you restart Access, the reports always return to the default
Report margins.

I've built a routine that remembers the last used 'Page Setup' printer
margins and paper dimensions etc prior to closing reports, so that the next
time the report is opened it will have the same settings. I can offer the
source code to anyone interested.

However, there's a couple of catches with this programming. The 'Page
Setup' stuff cannot be modified while the Report is open, so I can't add the
routine to the Report_Open() event. For the report to open with the saved
'Page Setup', the settings need to be implemented before the report is
opened.

Normally this would not matter for 'mdb' database, I just modify the report
opening routine in my switchboard.
But because I save my databases as 'mde' files prior to giving it to my
friends, my routine won't work, simply because mde reports cannot be
modified in design mode.

Has anyone else worked out a way of fixing report setting programatically?

I guess fixing report margins isn't possible for mde files? Would
supplying a runtime version of Access2007 allow Report margins to be saved,
or do they keep defaulting back in that version too?

Dom

"Dominic Vella" <dominic.vella (AT) optusnet (DOT) com.au> wrote

Dominic Vella wrote:
This is absolutely not true. There was a bug in Access 2000 that caused you
to lose your page setup settings but that was corrected in a service pack.
I have never heard of it in any other version.

It has always been true that if you have margin settings that are beyond the
capability of your printer driver that the max (or min) setting of the
driver takes over, but that is not the same thing as having all the settings
return to the defaults.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Thanks Rick, I appreciate you taking the time to reply.

What can I say, but that can't be just my bad luck, that every client of
mine that requires a 'Page Setup' fix are all using 2000 SP1. Actually, my
computer has 2000 SP3, and the problem is still there. As I said, I think
it's just Access2000 altogether as nearly all my clients use 2000. Well,
this is very interesting.

I love it when I hit brick walls. Makes life exciting. I notice that
these brick walls appear more when you actually can push Access to it's
limits.


Dom



"Rick Brandt" <rickbrandt2 (AT) hotmail (DOT) com> wrote

Dominic Vella wrote:

a specific report? Do all people use the same printer? If so, have you
gone to the printer mfg and dl'd the latest driver for the printer?
Does the report maintain the same orientation; portrait/landscape? Is
it the margins that are the problem? What happens if you use a smaller
font and move the fields around a bit so the margins are in an
acceptable limit?