Solved Export Form as PDF (1 Viewer)

Sarah.M

Member
Local time
Today, 23:07
Joined
Oct 28, 2021
Messages
303
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
 
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:07
Joined
May 7, 2009
Messages
16,881
checkout ExportWithFormatting macro.

or

RunMenuCommand
PrintObject
 

Sarah.M

Member
Local time
Today, 23:07
Joined
Oct 28, 2021
Messages
303
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!
1636970293186.png
 

Attachments

  • PrintForm.accdb
    1.9 MB · Views: 316

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:07
Joined
May 7, 2009
Messages
16,881
i made forms from the 4 stat queries.
see if this will work for you.
 

Attachments

  • PrintForm.accdb
    2.6 MB · Views: 324

Pat Hartman

Super Moderator
Staff member
Local time
Today, 16:07
Joined
Feb 19, 2002
Messages
36,974
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.
 

Users who are viewing this thread

Top Bottom