Form won't print!

[jibb]

Hello,

I have an access form that won't print or print preview. It just takes ages saying formatting and doesn't do anything!

Any ideas??

 

[vbaInet]

Rebuild your form.

 

[missinglinq]

vbaInet is assuming that your Form has been corrupted, which is a good guess. But just out of curiosity, since the onset of this problem, have you tried to print anything else from your app? Access won't even allow Print Preview if it cannot detect a printer connected to the PC it's running on.

Also, what version are you running and what service pack? Version 2007 initially had a number of printer related problems.

Welcome to AWF!

Linq ;0)>

 

[jibb]

The problem was solved when I removed the page numbering. But now when i print it doesnt show any of the detail - just the header and footer...

 

[missinglinq]

Originally you spoke of a Form that wouldn't print:

I have an access form that won't print or print preview.

Now you sound as if you're actually talking about a Report that won't print correctly.

The problem was solved when I removed the page numbering...

Which is it?

Linq ;0)>

 

[jibb]

A form.

It is a purchase order with all supplier details in the header, product details in the detail and totals etc in the footer. When i print it it shows the supplier details and the totals but not product details.

 

[vbaInet]

You really should be printing from a report, not a form. This is what they are there for and are far better at this. Look into saving your form as a report and printing the report instead.

 

[jibb]

Hello,

It is for entering purchase orders - It draws the information from tables and writes them to another table. In form view it all shows fine but when I print or do a print preview nothing shows apart from the header and footer.

 

[vbaInet]

Which is why I would re-iterate that printing should be done via reports.

 

[jibb]

All sorted and working fine as a form - thanks for your help.

 

[vbaInet]

Good to hear jibb!