Report Preview

[Little Penny]

How do I open a report so that it previews at 100% instead of fit.
By opening using a command button in a form and by double clicking the report icon



Thanks

 

[fredg]

How do I open a report so that it previews at 100% instead of fit.
By opening using a command button in a form and by double clicking the report icon

Thanks

If you use a form's command button click event:

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdZoom100

 

[Little Penny]

Thanks that worked.......

If you use a form's command button click event:

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdZoom100