Cant do a Print Preview in an .mde file?

[Dherrera]

why doesnt the print preview feature work in an mde file? is there a way to be able to do a print preview in an mde file?

thanks

 

[batteam]

If you specify it to do a preview, it should work.

If your print command is something like:

cmdPrintReport_Click()

Dim rptName as string
rptName = "myreportname"
DoCmd.OpenReport rptName, acPreview

End sub

it should show the report on your monitor.

 

[Dherrera]

if a user has their margins set to 1' and i set the margin for a report to .5', will the 1' margins overide the .5' margins? this is in an .mde file.

 

[batteam]

Whatever you set the report margins to in design view will be the settings for who ever uses the report.

If you set the margins to .5" then save the changes, then open the report in design view on your user's PC, you should find the margins at .5". You're not changing margins on a PC or a printer, your changing margins on the individual report so who ever uses the report will use the margins on that report.

Now, if you allow your users to open reports in design view and change margins, well then all bets are off and the report will then print according to what the new report margins are set to.

Good Luck.