Need urgent help!!

[Derek Brown]

Hi all

Can't save report page setup in MDE.

The idea was that users of my app would be able to use there own
letterheaded paper when printing letters to customers. But Letterheads
require repositioning of controls. I was planning to use margin settings but
when you change page setup in MDB files and close the form the new printer
page setup is saved. They are not saved in MDE files. So the user would have
to reset them every time a print was needed. I need a solution obviously had
a good browse on Google with no result. Any Help, ideas.

Would the only solution be:
to produce a form that sets the position of the
controls on the report in the on format property of the report. I.e.
ControlA.Top = Forms!PageSetupForm!Top
ControlA.Left = Forms!PageSetupForm!Left

 

[SA]

Derek:

You could do it with a form, but more than likely you'd want your data to be
stored, so you could use a form to gather the information and store it in a
table. Then in the report's On open event, retrieve the data into module
level variables.