Changing A Form Tab Control (Access 97)

Topic

New Reply

Is there a way to change the properties of a tab control once it has been placed on a form? I inherited a form that looks nice, uses a tab control, but now looks crowded and requires a horizontal scroll bar to see all the tabs. I am aware that you can set a tab control to multiple rows BEFORE you place it on the form, but cannot for the life of me find it in the properties of the tab control that already exists. Am I crazy?

Thanks!

Kwvh

Reply | Quote

Replies

You can use the Tab Control’s MultiRow property. This property can be set at runtime as well as in design mode. Example of sub that toggles property on & off when button clicked:

Private Sub TabButton_Click()

Me.TABCTL1.MultiRow = Not Me.TABCTL1.MultiRow

End Sub

Small sample db (A97 format) attached that illustrates this, form has Tab Control with 6 tabs (Pages), the button toggles them from 2 rows to single row or from single row to 2 rows.

HTH

Reply | Quote

Mark,

Thanks again for your solution. It works great! That is a super control you have that allows switching of the fly. I never considered that. Tunnel vision I suppose.

Ken

Reply | Quote