Tab Controls in Acess

Posted on 2007-10-02
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

    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.
    LVL 7

    Assisted Solution

    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

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now