Printer object bug with Access 2003 - confirmed by Microsoft Corporation

[ellipsys]

- Open Access 2003
- Create new database (2000 or 2002/2003 format)
- Create a report and insert a label in its Detail section
- Save the report as Report1
- Copy Report1 as Report2
- Open Report1 and insert Report2 in it as subreport
- Save Report1
- Create a form and use the wizard to insert a button which can open
Report1 for preview
- Go to VBE and navigate to the Click event of the button
- Change the following two lines

stDocName = "Report1"
DoCmd.OpenReport stDocName, acPreview

with this four lines

stDocName = "Report1"
Printer.PrintQuality = acPRPQMedium
DoCmd.OpenReport stDocName, acPreview
Printer.BottomMargin = 5

- Save form as Form1
- Open the form normally
- Click the button
- Here is the bug

I contacted Microsoft Italia (beacause I live in Italy). They informed
Microsoft Corporation which replied confirming it's a bug for Access
2003 and will be corrected in the future. They didn't tell if the
problem will be corrected with a specific patch or with Service Pack 2
for Office 2003.

You will not find any documentation in internet (neither in Microsoft
web site nor in MSDN nor elsewhere) until a correction will be
developed.

I hope this could help.

 

[GINA LA SALA]

Je n'ai vu qu'un seul message français, est ce un hasard ?

 

[Tom Wickerath]

Please resist your urge to multi-post. If you really feel the need to post to more than one
group, do so at the same time, so that if a person replies to your message, all groups will
receive the reply. Otherwise, you can waste people's time providing duplicate answers! Allen
Browne provided a reply to your question on comp.databases-ms.access:

http://groups-beta.google.com/group...e_frm/thread/334abc51a9417d6/fbc052547fd4b14a


Tom
_____________________________________

- Open Access 2003
- Create new database (2000 or 2002/2003 format)
- Create a report and insert a label in its Detail section
- Save the report as Report1
- Copy Report1 as Report2
- Open Report1 and insert Report2 in it as subreport
- Save Report1
- Create a form and use the wizard to insert a button which can open
Report1 for preview
- Go to VBE and navigate to the Click event of the button
- Change the following two lines

stDocName = "Report1"
DoCmd.OpenReport stDocName, acPreview

with this four lines

stDocName = "Report1"
Printer.PrintQuality = acPRPQMedium
DoCmd.OpenReport stDocName, acPreview
Printer.BottomMargin = 5

- Save form as Form1
- Open the form normally
- Click the button
- Here is the bug

I contacted Microsoft Italia (beacause I live in Italy). They informed
Microsoft Corporation which replied confirming it's a bug for Access
2003 and will be corrected in the future. They didn't tell if the
problem will be corrected with a specific patch or with Service Pack 2
for Office 2003.

You will not find any documentation in internet (neither in Microsoft
web site nor in MSDN nor elsewhere) until a correction will be
developed.

I hope this could help.