How to print duplex Access Report

[NewVBA]

Hello,

I have my report set up correctly. In print view it looks good. When I send it to the printer to print duplex, it prints front to back and ignores the page ejects. I’m not well versed in VBA; I'm looking for code and how to insert it into the right access area. I’ve seen code (if this is going into the right direction)

DoCmd.OpenReport "myreport", acViewPreview,,,acHidden

Reports("myreport).Printer.Duplex = acPRDPHorizontal

DoCmd.OpenReport "myreport", acViewPreview

But have no clue how to actually put it into access. Thanks in advance for helping out a newbie

[zmbd]

I don't understand what you mean by "page ejects"

[NewVBA]

Sorry for the confusion. When I send the document to the printer to print duplex, it doesn't seperate each group when the group changes, it just prints all of it together front to back. Does that make sense? Thanks for the patience

[NewVBA]

How to print a report in duplex

I don't understand what you mean by "page ejects"

I think I replied incorrectly, I appoligze. Sorry for the confusion in my post. When I send the document to the printer to print duplex, it doesn't seperate each group when the group changes, it just prints all of it together front to back. Does that make sense? Thanks for the patience

[Rabbit]

Do you mean that it's not putting in a page break on a new group? Or it's not going to a new sheet on a new group?

You should be aware that a sheet of paper has two pages. If you want each group to go on a new sheet, you just need to insert two page breaks after each group.

[NewVBA]

Rabbit

sorry hit the wrong button. Not my day. It's not going to a new sheet on a new group. I put 2 page breaks after the unit footer and page footer. No go

[Rabbit]

I don't know what a unit footer is but just put two page breaks in the group footer. It works for me.

[NewVBA]

Rabbit

Unit is what I grouped on and created a footer. I put the page breaks in the group footer and it still does not break each group. I set the Lexmark printer to print duplex, could it be the printer?

[zmbd]

NewVBA:
If you would, please review the information within the following links.
It is very importaint that the standard names/terms be used... not only so that the Experts can understand your question, but also, so that you can understand the answers given to you.

> Introduction to reports
> Create reports for a new database - Online Class offered by MS
> Description of frequently used terms in Microsoft Access
> Database design basics

[NewVBA]

I will do that. Thank you for the information

[Rabbit]

Well, it could be your printer. I mocked up a report. Put in a group, put page breaks in the group footer, and printed it in duplex and it came out fine.

[zmbd]

Ahhh.. hit tab and enter...

Yes, printer settings can also botch things.
If you have your printer set to print two per page, front and back, then you have four "pages" per sheet of paper.

So In one report I have, with the printer setup as above, the first 61 pages for Company "A" print on 17 sheets of paper with page 61 on the front left side of the paper and the next company ( "B" ) on the right side of the paper (sheet 17).

What I suspect you'd want in this situation is that Company "B" start on a new sheet of paper (sheet 18).

So... try the following: Duplex reports: start groups on an odd page
>>>Note, this would be for 1 page per sheet of paper. To solve the situation I have described would take an additional amount of magic as with 2 pages per sheet, you get 2 odd pages per sheet so the break is supper special!!!!!

[NewVBA]

Thank you.. Thank you.. Thank you ALL. I've been searching for ever. This works. One last stupid question please, since I am so new at this site, and have clicked so many buttons to reply etc. Where is the "choose as best answer button", I think I clicked it before, but I did not mean to. I want this to be the best answer. Again sorry for my lack of knowledge