printing forms
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Printing Forms

Printing Forms

resolvedResolved · Medium Priority · Version 2003

replyReply Fri 8 May 2009, 15:51Delegate Charlotte said...

Charlotte has attended:
Access VBA course

Printing Forms

Is there a way of printing just the first record from a form instead of all?

For upcoming training course dates see: Pricing & availability

replyReply Mon 11 May 2009, 11:22Trainer Stephen said...

RE: Printing Forms

Hi Charlotte

Thank you for your question

You can use the printout method of the DoCmd object. This method allows you to specify a start and finish page of the form or report in question.

For example

DoCmd.PrintOut acPages, 1,1

prints the first page of the active form

Hope this is useful

Regards

Stephen

Mon 18 May 2009: Automatically marked as resolved.

 

Please browse our web site to find out more about
training for microsoft access and other Microsoft training courses.

Access tip:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard