Tab Control & Pages - "Disable" Inactive Pages

[sathandle]

Is there a way in Access 97 to show pages in a tab control that do not have the focus as enabled = false? I have tried the following:
1. disable the entire tab control & change the on click event of the "active" tab to change that page's property of enabled to active. No click events are available when the enabled property for the tab control is active. - doesn't work
2. Set the picture on each page to the windows check mark. Set the on change of the tab control with the following code:
Dim intPageIndex as integer
Dim pge as Page

intPageIndex - Val(Forms![tab testing]!tab)

For each pge in Me!tab.Pages
If pge.PageIndex = intPageIndex then
Me.Picture = Me!tab!Page1.picture
'When the above code executes I get the error "Microsoft Access can't open the file '(bitmap)'."
Else
pge.Picture = ""
End If
Next pge

Overall effect: When you click on X Page in Tab Control I want X Page to Show as "[check mark] Page 1" and the rest of the Pages to show as "Page 2", "Page 3", etc.

Any help would make me - - dance with Joy!

Thanks,
SATHandle

 

[LarryDeLaruelle]

Tab pages do have an Enabled property but it will not do what you want.

An alternative would be to use the page's visible property.

Set it to no if you do not want it shown. You can then use code (probably some after update event on a preceding page) to set it back to visible.

Does that help?

Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[sathandle]

Unfortunately no, the visible property makes the entire page invisible and you don't even see the tab, so the user never even realizes that the tab is there. I need the tabs to stay and the titles of the inactive tabs to be either greyed out or not have a check mark.

 

[LarryDeLaruelle]

Don't think you can do that with tab controls.

I have used the visible property to display only the page I want the user working on.

To move to the next page, I use the after update event of the last input control to set the next page visible and the previous page to not visible.

Clunky, but in the case where I needed to use it, effective.

Sorry I couldn't be more help. Larry De Laruelle
ldelaruelle@familychildrenscenter.org