Tab Control - greyed out Page non-selectable

[cjashwell]

Hi all. Is it possible to have a Tab control with one or more Pages greyed out and non-selectable by users until certain conditions are met? For example, until a value is selected in a list box on Page 1 of a Tab control, Page 2 is greyed and can't be selected. I have seen this implemented in other development environments (e.g. Oracle forms) but not in Access.

I have spent about 40 minutes searching for this, and can't find any indication that it is possible, but I would be very grateful if someone can confirm.

I'm using Access 2003 on Windows XP SP2.

Thanks in advance.

 

[seaport]

When you disable a tab page, all controls in that page are disabled. Although the user can still select that disabled page, the user cannot do anything except for looking at the page. I think that is the result you want.

code for disable the page

Page12.Enabled = False

An alternative is to make the page invisible, like

Page12.Visible = False

Seaport

 

[TheAceMan1]

How are ya cjashwell . . .

You can also [blue]hide/unhide[/blue] a page by using its [blue]Visible[/blue] property!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[cjashwell]

Thanks for the replies. I was trying to replicate a behaviour I'd seen in Oracle forms, where the tab is actually not selectable. The page.enabled = false functionality isn't quite what I want, but it will do.

Thanks for saving me from spending hours trying to figure out how to do something that basically can't be done!

Many thanks and best wishes.