Print a Form

[Guest]

How can I print one record of a form? I want to be able to print it on the
form layout and not an access report. Currently, if you try to print a
record from a form you get all records on the form. Using Access 2000.

 

[Guest]

Open your form in design view and enter a 'Page Break' at the very bottom of
your form. Save your changes. Now each record is on a sepearte page simply
print the one you want.

Daniel

 

[John Vinson]

How can I print one record of a form? I want to be able to print it on the
form layout and not an access report. Currently, if you try to print a
record from a form you get all records on the form. Using Access 2000.

You can do a screen-print (ctrl-PrtScn and copy from the clipboard
into Word or some other image-capable program, or using a tool such as
SnagIt); but within Access, forms are designed for onscreen use,
Reports for printing. Neither does the other's job very well.

What you might want to consider is opening your Form in design view,
and saving it as a Report. Then open the Report based on a query
referencing the Primary Key value on the form to print just that
record.

John W. Vinson[MVP]

 

[John Vinson]

Hi John,

Your suggestion to save the form as a report worked. I never new I could do
this. I created a macro to open the new report based on a query that prompts
user to enter a unique code for the record needed. This code is an
autonumber found on each record. Now all I need to do is create a button on
original form to run the macro and print the record. Thank you very much!

You don't even need the user to enter the autonumber - and you in fact
should generally never allow a user to even SEE an autonumber (they
develop gaps, and can become random; they're best kept behind the
scenes).

Instead use a criterion referencing a control on the Form which
contains that autonumber (I'd make the control invisible); just

=[Forms]![YourFormNameHere]![ThatControlNameHere]

on the criteria line.

John W. Vinson[MVP]