Blank print preview form

[swee]

When my form has a blank print preview screen, does that mean it has exceeded the width and/or height of the document? What other reasons can account for this?

 

[Rich]

Forms are not designed for printing, use a Report

 

[swee]

The form is an interface for a purchase order form and after filling in, I wish to provide the user with an option to print. How do I print it as a Report, as you have suggested.

 

[maxmangion]

in the design view of your form, go to File -> Save As and save it as a report.

 

[swee]

I can't find the option to save it as a report. I'm using A97. Is it only available to the newer versions?

 

[maxmangion]

well i am not sure if that option is available in Access 97, because i am using 2000, but make sure that you are in the design view of the form, because in Form View i do not have the option neither.

 

[Rich]

It's not included by default. You have to add it to the toolbar by customizing it

 

[swee]

Are you referring to the "File - Save As/Export" option?

 

[maxmangion]

on my version it is File -> Save As.

 

[swee]

After you click that, does it tell you to save the form to an external file or database or within the current database?

 

[maxmangion]

it gives me the option to enter a name for the form, and to choose the Type between Form, Report or Data Access Page.

 

[dt01pqt]

Like Rich said if you want print data the best way to do it is with a report. If you need to print the form for layout and development purposes try doing a screen grab and then printing it from paint.

If you still want to print the form try setting the form to layout for print. On individual controls make sure Display When is set to always. Use page setup to determine the column size, plus the orientation of paper. Finally use print to determine the number of pages to print.

 

[swee]

I have tried adjusting the page setup but it doesn't help. The reason I would want to print from the form is because I would want the user's input to be printed as well.

Is there a way for me to import the fields, together with the user's input, to a Report? I have attached a picture of my form. I wish to print it on that format. Thanks for the help.

 

[dt01pqt]

You can print a report with any kind of layout, pictures you want with the field linked to the table or the form itself. Are you trying to print just the current record or all of them?

 

[Rich]

View> Toolbars> Customize> click FormView > select Form/Report Design on the CommandsMenu, drag the Save As Report command onto your toolbar.