Print Current Form

[michaelfischer]

I want to have a button on a form so that the form using only the current record is printed out. Can someone please help me.
Thanks.

 

[Graham T]

If you are wanting to print out the form containing only the current record in form view then you can attach a simple macro to a command button on the form.

In your macro set the action to PrintOut, and in the action argumants set the Print Range to "Selection".

HTH

 

[saintsman]

You will find the wizard will help you with this when you put a command button in your design. One thing though, if you put a button on a form and print the form it will include the button as well.

 

[David R]

You can set your command buttons Properties>Format>Display When: Screen Only

 

[Graham T]

Or use the SetValue Action to make the command button not visible when printing the form, and set visibility back on completion of printing.

Graham

David - saw your reply after I had submitted mine.

It's amazing how we sometimes miss the *easy* solutions.

[This message has been edited by Graham T (edited 01-30-2002).]

 

[David R]

*grin* One of the benefits of starting new (6 months ago never seen MS Access) is that you don't learn all the bad habits.

NOT to say that coding is a bad habit, but sometimes there are simpler ways.