Setting Tab Style in VBA

  • Thread starter Thread starter Mark A. Sam
  • Start date Start date
M

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.
 
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,

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



Cheryl Fischer said:
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

Mark A. Sam said:
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.
Click to expand...
Click to expand...
 
Back
Top