I have an Access XP Report which prints cheques(checks). It works real well except for one feature: MARGINS and PAGE SIZE! It has been my experience that Margins are 'printer' and printer driver dependant. Some printers will allow 0 (Zero) Top and Bottom margins and some cannot. Yesterday, I found out that the same exact printer will allow you to set "Unprintable Areas" in Windows 98 but NOT in Windows XP. Microsoft's website mentions nothing about "Unprintable Area" so it must be a Printer Driver issue. An Access XP Article does address the issue of printing Access Reports with 0 Top and Bottom Margins. The Article simply states that even if you code the layouts in VB, the Top and Bottom Margins will still default to their maximum size based on the printer setup and driver.

Letter size cheques/checks work real well: One DB record = one report page. The problem is with legal size(2 part) cheques. This type of cardstock fits two(2) payment items on a single 8.5 x 14" legal size cardstock.

Historically, I have found that with this type of cheque/check, works nicely with a single DB record - and the corresponding controls - properly laid out on a Report with the Report Height being EXACTLY 7 inches. The Top and Bottom Margins Must then be set to 0 (Zero). This means that two DB records will print off on one 8.5 x 14" cardstock cheque/check and the layouts advance properly on all subsequent pages.

PROBLEM:

As stated earlier, sometimes Windows will not allow you to set the Top and Bottom printer margins to 0 (Zero). If this is the case, the second DB record will actually be printed on the second cardstock cheque/check rather than being the second record (Bottom payment) on the first page. If I set the Report Height to less than 7", then the Report controls print slightly higher and higher on subsequent pages. I have tried placing a hard page break exactly at the bottom in the Design section of the report but this just means that a full cheque/cheque is skipped on the bottom of the legal size cardstock.

Does anyone have ANY suggestions on how I can control this? Would I be better off using another "Paper Size" in the Printer Setup?

Since most of what I send out is in a .mde format, and consequently, my users do not have access to the Report Design section. I have successfully built a very user-friendly GUI which allows the user to design the Report control layouts without having to go the Design View. The last hurdle is with regards to this Page Margin/Size issue.

ANY input will be appreciated.

Pat