Print preview tab not active

[suepowell]

Hi,

Does anyone know how to get the print preview tab to appear as soon as a report is opened.

It does if I open a report from the navigation bar, but not always if I open it from a form.

I think it will be much easier for my users if I can get it to open everytime.

I do have a custom ribbon, but am still using the normal tabs as well.

Thanks

Sue

 

[Fifty2One]

In the event to print you need to change the acNormal to acPreview./
like this...

DoCmd.OpenReport stDocName, acNormal, , stCriteria
DoCmd.OpenReport stDocName, acPreview, , stCriteria

Hi,

Does anyone know how to get the print preview tab to appear as soon as a report is opened.

It does if I open a report from the navigation bar, but not always if I open it from a form.

I think it will be much easier for my users if I can get it to open everytime.

I do have a custom ribbon, but am still using the normal tabs as well.

Thanks

Sue