Exporting A Form

[paul.clarke]

Hi.

I need to be able to export my "form" into a pdf format, or something similar. Excel just lays the data into 1 row and does not include the ole object(pic) or subform data.

I need to keep the forms design/format and ole object and subform data.
(so it looks like is does in access) (like a screenprint)

I know you can export a "report" as a snapshot, this would be ideal if i could do the same with my "form"

Any ideas?

Thanks

 

[HiTechCoach]

I never print forms. I create a report/sub report that look just like the form. I find just to many limits and issues.

TIP: You can even take a form and "Save As" a report to convert it!

What version of Access are you using?

 

[gemma-the-husky]

best to start from a report, not a form

stephen lebans has a nice routine to change a snapshot "snp" file into a pdf

 

[boblarson]

stephen lebans has a nice routine to change a snapshot "snp" file into a pdf

It doesn't just do snapshots to PDF but also regular reports. Find it here.