How do you add a 'print screen' button to a form?

**familylink** · 06-27-2010, 06:25 PM

Hi,
As per the heading, im wondering how to add a command button to a form which prints the form when clicked?

Cheers,

Familylink

**shg** · 06-27-2010, 07:06 PM

VBA has a PrintForm method; I've not used it, but have heard that it prints at screen resolution, not printer resolution.

An alternative would be to copy the data to a sheet and print that.

**familylink** · 06-28-2010, 02:53 AM

I have tried these code examples:

Please Login or Register  to view this content.

But both of them just print a blank page. A print screen command would probably work but im not sure how to do that.

**royUK** · 06-28-2010, 03:18 AM

A userform is not really designed to print, I always use a sheet set up as a print option which is displaying the details in the form, which is what shg is recommending.

Leith Ross has posted code to print a UserForm though

**familylink** · 06-28-2010, 03:32 AM

Alrighty,
I have it printing using:

Please Login or Register  to view this content.

Just working on making it print in landscape, I will post the code when I figure it out. Unless anyone else knows how?

How do you add a 'print screen' button to a form?

LinkBack

Thread Tools

Rate This Thread

Display

How do you add a 'print screen' button to a form?

Re: How do you add a 'print screen' button to a form?

Re: How do you add a 'print screen' button to a form?

Re: How do you add a 'print screen' button to a form?

Re: How do you add a 'print screen' button to a form?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions