Print one record on one page using a print button

[Chris]

Hello,

I am using Access 2007 and am trying to print a single record on one page
using the PrintRecord command button. However, everytime I do this I get 2
pages, including a separate page that only includes the Page Header content
and the Print button which was created in the details area. I am sure this
is simple but I am just not getting it. Thanks in advance,

Chris

 

[NG]

Hi Chris,

the easiest way to print the record is to create a report with the lay-out
you want. The printcode of the onclick event of the PrintRecord comman
button could read something like (assuming the ID field of the record is
called recID and is shown on the form in the text control txtID) :

DoCmd.OpenReport "NameOfTheReport", acViewPreview, , "recID = " & Me.txtID

greetings
NG

 

[Chris]

Thanks NG,

I will give this a try and get back to you if it works. I got it to work in
a form by manipulating the positional formatting. The reason I am using the
form is because I wanted to use the built in filtering tools which are not
available in the Reports.

Cheers,

Chris