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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

print form tabs

Status
Not open for further replies.

TrollBro

Technical User
Sep 4, 2004
98
US
Hello

I have a form with a Pagectl with several tabs. I need to give the form user the ability to print the form and show the tab selected. I can print the form, and it shows the data from the tabe selected, it just doesn't identify "show" or "print" the tab that was selected. Is there a way to actually print the image of the page control and tabs?

thanks
 
Use a report instead.
A form is for display and for printing a report is adequate.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 

Keeping in mind PH's good advice about printing reports/subreports rather than forms, you could put a label on your form just above the tabbed control and use code like this:

Code:
Private Sub TabControlName_Change()
 Select Case TabControlName
  Case 0  '1st page
   PageLabel.Caption = "First Page Title"
  Case 1  '2nd page
   PageLabel.Caption = "Second Page Title"
  Case Else
 End Select
End Sub

To have it appear when you open the form or move record to record you'd need the same control in the Form_Current event as well.


The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!
 
Thanks Missinglinq

Your idea looks like a good solution for me - clean and simple.

PHV thanks as well - my search resulted in finding a similar recommensation - i.e. use a report (and yes, if it was for my own purposes I would do exactly that), but the point was that I needed to provide some data entry users with the ability to simply/quick do a screen print which they could then use to show a maager what issue they were facing that they need help with.

Thanks again to you both!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top