Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print Active Record

Status
Not open for further replies.

JaySwan

IS-IT--Management
Oct 24, 2005
1
0
0
US
I have a form with a subform that alows users to enter data in the Sub-Form only.
How can I get a button to print only the data in the form and sub-form. I can get the print screen but then I run into formatting problems. Anyway to make the form print 80% of the orig size.
Or can I take the active record and point it to a report to print out...
Thanks,
Jay Swan
swansoftware@yahoo.com
 
I have this attached to my button for printing a form:

Code:
DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, A_SELECTRECORD_V2, , A_MENU_VER20
    DoCmd.PrintOut A_SELECTION

What I do is go into the design of my form and get it set up the way I need it to look printed (IE. landscape, set margins, etc).

HTH

cew657
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top