How do I change the position of the tabs on a Tab control in Access 2010

[tfurnivall]

I'm tring to use a Tab control in Access 2010, and I would like to have the actual tab s at the bottom of the form, rather than the top. There seems to be no way of doing this.I know it is possible in Excel (using the Multi-Page control), and wonder why this simple feature seems not to exist in Access?

[Missinglinq]

Why is an Excel feature not available in Access? Because it's Access, not Excel!

If you want to do this, you'll have to customize it yourself:

1. Select the Tabbed Control itself (not a Page on it) and go to Properties - Format and change the Style Property from Tabs to None
2. Place a series of Command Buttons along the bottom of the Tabbed Control
3. Use code for these Buttons as below

Private Sub btnPage1_Click()
 Me.TabControlName = 0
End Sub

Private Sub btnPage2_Click()
 Me.TabControlName = 1
End Sub

Note that the page index is Zero-based, i.e. the first page is 0, the second page is 1, and so forth.

Linq ;0)>

[tfurnivall]

Thanks, Linq!

That's what I was afraid of.

Of course the idea of maintaing consistency across the products that use VBA is such a patently silly one, I'm surprised that MS even has the use of "Dim" the same in all of the Office products.

Thanks, at any rate, for your suggestion. It's an elegant solution to a (blindingly) definite omission.

Tony

[Missinglinq]

The thing that you have to keep in mind is that the Boys of Redmond didn't sit down one day and decide to build a suite of office apps from scratch; the various components each had its own unique origins, and all in all, they can be made to work together quite well.

Glad you find the workaround useful!

Good luck with your project!

Linq ;0)>