Stop Cursor Changing to Zoom 1

[MeldrethMan]

I need to give users the option of limiting the records sent for printing and this code works fine on a command button in the header.

DoCmd.OpenReport "rptCRBDue", acViewPreview, , "CRBDaysRemaining <= 60"

Trouble is the cursor then changes to zoom mode, either after printing or cancelling the print.

I'd also like to fix the report layout so a user can't change width, zoom, etc. Have set Auto Resize and Fit to Page to No, and Border Style to Dialog but these don't prevent changes.

 

[dhookom]

Are you suggesting your mouse cursor changes to a magnifying glass and stays there when running the report?

Duane
Hook'D on Access
MS Access MVP

 

[MeldrethMan]

Yes exactly, on clicking the command button on the menu

DoCmd.OpenReport stDocName, acPreview

the cursor becomes a magnifying glass.

If I start the report manually from the object list the cursor is a normal pointer. But on clicking the command button in the report header adding the condition "CRBDaysRemaining <= 60", the cursor again becomes a magnifying glass and stays that way.

 

[dhookom]

acPreview" opens with the magnifying glass which makes sense. I try to never open reports in "report view" which has a typical "I" cursor.

I'm not sure what is wrong with the print preview and magnifying cursor. Users can't change stuff in this mode.

Duane
Hook'D on Access
MS Access MVP

 

[MeldrethMan]

Okay thanks, that seems to mean that if I preview the report with all records showing I can't then use a command button on the report to print just a selection?

 

[dhookom]

I allow the user to filter the report prior to opening it in print preview. I'm not familiar with the report or layout views.

Duane
Hook'D on Access
MS Access MVP

 

[MeldrethMan]

Thanks Duane, I now better understand the way reports are presented and have a workable solution.