Report changes from landscape to portrait when distributing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an app under development, and for which I therefore distribute updates
periodically (split FE/BE, and I am just sending out a new FE) to two clients.

I am using System Default printer on my development station. For both
clients, some of the reports appear to be in portrait (i.e. the visible page
size in the preview looks like a portrait page) when using this:

DoCmd.OpenReport "FormName", acViewPreview

However, when I click on Page Setup on the client machine, it correctly
shows Landscape. If I change it from Landscape to Portrait and back again,
the preview displays correctly and retains the correct settings for future
uses of the report on the computer.

The whole process starts over again when I distribute a new copy of the BE.
The same thing happens on their Access 2003 runtime machines as on the one PC
that has the full version of Access 2002.

Any ideas?
 
is the Name Autocorrect option turned off in the FE and BE databases? if
not, suggest you do that, and then compact/repair each. note that Name
Autocorrect problems can be hard to shake free of, sometimes. you might want
to create a new, blank db for the FE, immediately turn off Name Autocorrect,
then import all objects (group by group) from the old FE, then
compact/repair. do the same for the BE, then link new FE to new BE.

hth
 
I always set up my apps with Name AutoCorrect turned off, and I went through
the exercise of creating a blank DB & importing everything several months
ago, to no avail.

In addition, I have replaced my development workstation with no change. I
have decompiled & recompiled many times during the development of this
application.

The strange thing is that it all works fine on my development system
without, and on the client computer, once I switch one (any) report from
landscape to portrait & back again, the rest seem to work fine until I copy
the next FE to the computer.

My only (wild) guess is that the margins are narrower than the default
margins for the client computer.
 
Back
Top