[AccessD] Is it possible to Programmatically Obtain the Name of all Tabs on a Form?

Heenan, Lambert Lambert.Heenan at chartisinsurance.com
Thu Mar 10 16:00:05 CST 2011


Tab controls have a Pages property, one Page per tab. so you can find out how many tabs with

MsgBox "Number of pages in TabCtl1:" & TabCtl1.Pages.Count 

And you can access the actual tab with

TabCtl11.Pages(n)

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Thursday, March 10, 2011 4:41 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Is it possible to Programmatically Obtain the Name of all Tabs on a Form?

I would like to be able to obtain the names on all TABs on a Form so that I can work with these names in VBA (Access 2007).

Thanks for your help,

Brad

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list