Setting Focus to a tab on Form Activate

How can I set the focus to a tab on a form on the activate command?  Thanks all
sbornstein2Asked:
Who is Participating?
 
jkaiosConnect With a Mentor IT DirectorCommented:
How about try these other combinations ...

MultiPage1(0).SetFocus
 - or -
MultiPage1.Pages(0).SetFocus
 - or -
MultiPage1.TabIndex = 0
 - or -
MultiPage1.TabIndex(0).SetFocus

Remember that some Collections start with Index = 0, usually "Controls" collections.
0
 
mladenoviczCommented:
SSTab1.SetFocus
0
 
ShauliCommented:
If you refer to the SSTAB (Tabed Dialog) then:

Private Sub Form_Activate()
SSTab1.Tab = 1   'or any other number, The number is the tab number you want to set focus on.
End Sub

S
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
sbornstein2Author Commented:
I am using VBA actually and I dont have the tab property.  I have a tab called MultiPage1 and the tab name is Page1.  My options under MultiPage1. are

pages
tabindex
etc.

I tried MultiPage1.TabIndex = 1 but no dice it still goes to another tab.
0
 
ShauliCommented:
I'm guessing here, but try:

Page1.Pages(1)

Where 1 is the tab number.

Let us know.

S
0
 
ShauliCommented:
Or maybe Page1.Pages = 1

But I'm unfamiliar with that vba tab.

S

0
 
sbornstein2Author Commented:
No dice.
0
 
ShauliCommented:
In that case I suggest you ask for refund @ customer support, and replace the question, and this times specifying its VBA and Multipage control. :)

Good luck,

S
0
 
sbornstein2Author Commented:
The answer is just .Value in VBA.  MultiPage.Value = 1
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.