Trying to write Code so that my Report opens in Print Preview Mode. 1

[KaayJaay]

I have this as a command for a button, DoCmd.OpenReport ("Total T by Date"), but when the user clicks it, it automatically prints, i am trying to make is so that it opens the report in print preview mode, but i dont know the extended parameters that allow me to do so. Any Suggestions?

KaayJaay

 

[PHV]

Something like this ?
DoCmd.OpenReport "Total T by Date", acViewPreview
BTW, have you even tried the F1 key with the cursor on the OpenReport word ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[KaayJaay]

This didnt work, it is saying that i need and "=" sign somewhere in the expression.

KaayJaay

 

[PHV]

Have you read my post ?
Get rid of the parens.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[KaayJaay]

Thanks Much

KaayJaay