Printing Report lacks page breaks

[Patfreem]

I have a report which my clients will use to look up particular records. After I look up the record # I run into issues printing. The Print dialogue box does not offer "Print Selected Record's"... it's grayed out. Also, in Datasheet view the report screen scrolls from one record to the next without any page break - which I added at the bottom of the Detail section - which doesn't appear to work. (the report has no header or footer). Maybe fixing the page break issue will solve the Print Dialogue problem (and why does the bottom margin say .57", and why won't it let me change it?). Odd.

 

[AccessMSSQL]

Try this in VBA from a form where the user searches for the record.

DoCmd.OpenReport reportname, acviewPreview, , "ID = " & YourID

*you can use acViewPrint to send directly to printer.

Search in Google for this: "Docmd.OpenReport Method" to see more syntax on this. I'd send you the link but I can't post links yet here.

hope this helps.

AccessMSSQL.com