Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Tab Controls in Acess

Posted on 2007-10-02
Medium Priority
Last Modified: 2013-11-28
I have a tab control which I am having some trouble with. I have a number of fields on my page which are not visible. I want to make a certain amount of these visible. Before I place these field in a tab control I used the VBA;

    For i = 1 To NoOfQuestions
      Me("Text" & i).Visible = True
      Me("Label" & i).Visible = True

Can someone tell me how I would modify thid for my Tab control. Something like;

Me.TabCtl75.Pages(Conditions).("Text" & i).Visible = True

Question by:andyb7901
LVL 77

Accepted Solution

peter57r earned 1000 total points
ID: 19997314
The tab control has no impact on code which refers to controls.
If the code worked before you added the tab control it will still work afterwards.

Assisted Solution

tward earned 1000 total points
ID: 19997564
If you only want some visible at certain times, why use a tab control?

Tab controls are usually for when you have too many controls to fit on a form, you divide them up among several tabs.  The tab controls which ones are on the screen at any given time.

If you want them all visible, use the tab, then the tab takes care of visible or not (all controls on the selected tab will be visible to the user).

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question