Print Preview opens in less than 50%

[kkshansid]

This code opens Print Preview in less than 50% which is not easy to read

DoCmd.OpenReport "rptCm", acViewPreview, , "C_NO like '*" & TXTCNO & "*'"

kindly help to open it in 100% view by default.

[TheSmileyCoder]

I am working in Access 2010 now, which works slightly different when it comes to report design, so I can't test this currently

Try setting the AutoResize and FitToPage to True.

[ADezii]

Wouold not a MAXIMIZE Command in the Open() Event of the report do the trick?

Private Sub Report_Open(Cancel As Integer)
  DoCmd.Maximize
End Sub

[zmbd]

Make it easy... nothing to add to the report unless you open in dialog mode:

right from the MS website:

 DoCmd.OpenReport stDocName, acPreview
    DoCmd.Maximize
    DoCmd.RunCommand acCmdZoom150

Of course stDocName is a string etc...
acCmdZoom150 sizes an 8-1/2" x 11" page so that the widith is visible across my LCD and about a 1/3 of the top page; however, I have a very nice large monitor that has the nifty rotate that allows me to turn the monitor longwise and see the entire page... :) so you may need to use acCmdZoom100 or acCmdZoom75