Tab Control Page Count

[Guest]

Hi All

In Access 2000/2/3 is there any way to determine how many pages a Tab
control has using VBA.

 

[Guest]

Hi Peter,

Here is an example:

Option Compare Database
Option Explicit

Private Sub Form_Open(Cancel As Integer)
MsgBox "There are " & Me.TabCtlName.Pages.Count & " pages."
End Sub


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Hi Tom

Brilliant, I learn something new every day in this group.

Thanks again.