Solved Export Form as PDF

[Sarah.M]

Hi, Plz note, My VBA is disabled for security reason.
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
I have a form and I want to export that form as PDF, but I could not setup the page for that Form, so how can I make page setup for a form not report? When I export the form as PDF , the form appears broken parts with 4 pages
I know report has page setup but form it does not have.
plz help

 

[arnelgp]

checkout ExportWithFormatting macro.

or

RunMenuCommand
PrintObject

 

[Sarah.M]

checkout ExportWithFormatting macro.

or

RunMenuCommand
PrintObject

Hi, thank you for reply,
I mean I want to export my Form directly to PDF, but forms does not give me page control or page setup or margins etc.
I will show u my problem in the picture below
Sample attached
plz help!

 

[arnelgp]

i made forms from the 4 stat queries.
see if this will work for you.

 

[Pat Hartman]

Forms are not optimized for printing. Create a report and export that.

It is fairly easy to do this, open the form in design view and choose the save as report option. That might be all you need to do. If you have a tab form, you will need to convert that to a series of subreports or just paste the controls on the main form if they are all bound to the main RecordSource.

 

[Sarah.M]

i made forms from the 4 stat queries.
see if this will work for you.

Thanks indeed!