Report cannot be printed

[seaport]

I got a report in Access 2000. It can be previewed OK. However, it cannot be printed out, or be converted to Word or Excel. In other words, I cannot output it to any device.

It is a rather weird problem. Any suggestions?

Thanks in advance.

Seaport

 

[lupins46]

In design view when you do File>printer what printer is shown?

 

[THWatson]

seaport
Sometimes Name AutoCorrect causes weird problems, especially with printing. Make sure Name AutoCorrect is turned OFF under Tools>Options>General

Another possibility...if you can Preview the report but nothing prints out, is the report being driven by a form that is being closed after the Preview is fired, so there is nothing to print?

Tom

 

[ZmrAbdulla]

In connections with lupins46's reply..
seaport, Have you changed the windows default printer? If yes a reboot will reset all.

________________________________________
Zameer Abdulla
Visit Me
The best thing to spend on your child is your time.

 

[seaport]

I figured out the problem.

I set up a public property of a class module that will be set to null once it is retrieved. In the format event, the value of the property is retrieved and the reprot runs OK. However, when the report is printed, somehow the Access report has to run the format event again so it only gets a null value.

I can understand that the code will not run correctly (so nothing is outputed) because of the null value. But, strangely there is no warning or error message at all.

The way I fixed it is to store the value of the public property to a report level variable at the Report_Open event. In the format event, the report level variable, instead of the public property, is retrived.

Seaport