Solved

Access Tab Control - Show Caption by Tab

Posted on 2008-09-30
3
395 Views
Last Modified: 2012-08-13
I have two tabs, one for Expenses the other for Budget Entry.  Unable to get the Caption for the form to read based on each tab - have tried On Change() and on Click.  

Help???
0
Comment
Question by:GR82BBlondie
  • 2
3 Comments
 
LVL 65

Expert Comment

by:Jim Horn
ID: 22606076
I highly recommend against this.
The form caption should describe the form, not the tab of a tab control that is currently active.

If you really wanted to do this, it would be the tab control's Click event.
Keep in mind that every time this is done it requires a form repaint, and that may be slow if your form has a lot of objects in it.

Private Sub YourTabControl.Click

Select Case YourTabControl.Value
   Case 1
       Me.Caption = "foo"
   Case 2
       Me.Caption = "bar"
End Select

Me.Repaint

End Sub
0
 

Author Comment

by:GR82BBlondie
ID: 22606367
Thank you for the response.  I understand not recommending it but it's being requested from higher up the ladder.  :)

Unfortunately this did not work.  

Private Sub TabCtl.Click (recieve and error message - Compile Error Expected: end of statement.)  Is this suppose to be Private Sub TabCtl_Click()  

Another quesiton:  Select Case TabCtl.Value - does that mean the value of the page?  I tried TabCtl.Value(0) and TabCtl.(0) but neither works.  

0
 

Accepted Solution

by:
GR82BBlondie earned 0 total points
ID: 22669664
Chose not to pursue this.  

Thank you.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question