Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Thanked 0 Times in 0 Posts

    tab control content indicator? (2002)

    My book database has a section at the bottom of the data entry form that contains several Tab Control Pages. Some of these Tab Control Pages have sub forms on them. Currently there is no way to know if content has been added to the sub forms without clicking on the related tab.

    Is there anyway to indicate that a non-visible tab control page has content? Can the "look" of the tab be made to change if there is content e.g. font color, weight of tab label? Or perhaps locate a check box on the main from just above the tab that becomes checked if content is present.

    Thanks for any suggestions on how to do this.

    Bob Holmstr

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Sint Niklaas, Belgium
    Thanked 0 Times in 0 Posts

    Re: tab control content indicator? (2002)

    I don't know for Access 2002 but in Access 2000 there is no way of changing the look of the tab.
    You can use code in the on current event of the form to change a checkbox.
    If you want to check if there are records in the subform use the recordcount function of the recordset of the subform.
    If you want to know if a field is empty or not use IsNull function.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts