How do I set the default tab?

dmr · #1 03-04-2010, 10:24 AM

I have a form with a tab control. The rightmost tab is always open when the form loads. I want the left-most tab to be open when the form loads. I can't seem to figure out how to change it.

I tried...
1) Me.TabCtl0.Value = 0
2) Me.TabCtl0.Value = 11
...in the form_load() sub. One of them should have worked!

Help!

vbaInet · #2 03-04-2010, 10:26 AM

Change the Page Index property of the page. They start from 0.

SOS · #3 03-04-2010, 10:28 AM

You can also just use the page name:

Me.YourTabPageName.SetFocus

dmr · #4 03-04-2010, 10:38 AM

Quote:

Originally Posted by vbaInet

Change the Page Index property of the page. They start from 0.

How can I do that?

dmr · #5 03-04-2010, 10:39 AM

Quote:

Originally Posted by SOS

You can also just use the page name:

Me.YourTabPageName.SetFocus

Thank you! This worked!

vbaInet · #6 03-04-2010, 10:51 AM

Quote:

Originally Posted by dmr

How can I do that?

Just FYI, right click the tab and click Page Order then move things up or down as you wish. You can also set it via the Properties Sheet on the Format tab by clicking on the Page you wish to make the first and set it to 0.

Glad SOS' solution worked for you.

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook calendar (Delete and update)	robyholmes	Modules & VBA	20	02-01-2010 12:19 AM
Formatting Pivot Chart via VB code	sphynx	Modules & VBA	0	11-21-2007 07:01 AM
Set Default of Field from Another Table's Field Entry	SaraRob	Tables	0	06-12-2006 03:39 PM
Query to fill in blanks within a table? Maybe some other way?	robjones23	Queries	11	03-21-2005 02:10 AM