dynamically create Tab Control possible?

[zhouzhendong]

Hi,
I just wonder whether it is possible to create Tab Control in runtime?
The reason I want that is as follows:
I wanna show a table that contains several categories of information of
clients, e.g., personal address/contacts, company address/contacts,
education backgrounds, working backgrounds, etc.
But not all persons have all those categories of information. I don't
wanna
show blank tab pages for those not having corresponding categories of
info.
So for each person, the number of tab pages may be different. I need to
construct the tab control at runtime.
Can I do that with VBA or any other way?
Thanks a lot

[Randy Harris]

<zh**********@hotmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Hi,
I just wonder whether it is possible to create Tab Control in runtime?
The reason I want that is as follows:
I wanna show a table that contains several categories of information of
clients, e.g., personal address/contacts, company address/contacts,
education backgrounds, working backgrounds, etc.
But not all persons have all those categories of information. I don't
wanna
show blank tab pages for those not having corresponding categories of
info.
So for each person, the number of tab pages may be different. I need to
construct the tab control at runtime.
Can I do that with VBA or any other way?
Thanks a lot

I've had excellent results making tab pages visible (or not) at run time. I
do it based on the permissions of the user logged in.

Me.TabControl.Pages("Invoice").Visible = RoleFinance

In the form open event.

HTH,
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.