Setting Tab Style in VBA

[Mark A. Sam]

I need to set the Tab Styles in VBA, but don't know how to address the value
of the property. According to help, there are constants,

vbTabs, vbButtons, and vbNone.

These don't work and don't return a value in the immediate window:

?vbNone

I tried

[TabCtl23].Style = acNone

and got errors.

I am working with A2k but also tried it on Access 2002.

Thanks for any help.

 

[Cheryl Fischer]

VBA Help on the Style property in Access 2002 offers no constants that I can
find. The example found there uses the numeric settings.

' Default (tabs)
[TabCtl23].Style = 0

' Buttons
[TabCtl23].Style = 1

'None
[TabCtl23].Style = 2


hth,

 

[Mark A. Sam]

Cheryl,

That's right. I found the description on A2k, hitting the F1 key while on
the Style property of the tab control. I can't paste it for you becuase I
am using A2K via a client's terminal server.

After checking the Style setting on A2002, I see 'that' help displays it
correctly. It must something with A2k help which is lacking (well so it
Access 2002 help...lol).

God Bless,

Mark

VBA Help on the Style property in Access 2002 offers no constants that I can
find. The example found there uses the numeric settings.

' Default (tabs)
[TabCtl23].Style = 0

' Buttons
[TabCtl23].Style = 1

'None
[TabCtl23].Style = 2


hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I need to set the Tab Styles in VBA, but don't know how to address the value
of the property. According to help, there are constants,

vbTabs, vbButtons, and vbNone.

These don't work and don't return a value in the immediate window:

?vbNone

I tried

[TabCtl23].Style = acNone

and got errors.

I am working with A2k but also tried it on Access 2002.

Thanks for any help.