Tags: access, andsluggish, asking, beloaded, control, controls, database, maximum, messy, microsoft, mysql, number, oracle, practice, sql, tab

Maximum Number Of Controls On A Tab Control

On Database » Microsoft Access

2,627 words with 2 Comments; publish: Fri, 04 Jan 2008 12:49:00 GMT; (25078.13, « »)

Is there a "best practice" maximum number of controls that can be

loaded on to a tab control before things start getting messy and

sluggish? I'm asking for a "best practice" maximum number across all

tabs and not the maximum number that is theoretically possible.

I figure that trying to add lots of controls to lots of tabs must

affect performance at some point.

Any help is appreciated.

All Comments

Leave a comment...

  • 2 Comments
    • Wayne wrote:
      Quote:
      === Original Words ===

      Is there a "best practice" maximum number of controls that can be

      loaded on to a tab control before things start getting messy and

      sluggish? I'm asking for a "best practice" maximum number across all

      tabs and not the maximum number that is theoretically possible.

      >

      I figure that trying to add lots of controls to lots of tabs must

      affect performance at some point.

      >

      Any help is appreciated.

      There is a maimum number of controls on a Form. Not sure about a TabControl.

      Think of it this way. A TabControl is just a handy way of toggling the

      visibility of a bunch of controls all at the same time. It likely has almost no

      affect on performance at all. Certainly not any that I have been able to

      perceive.

      --

      Rick Brandt, Microsoft Access MVP

      Email (as appropriate) to...

      RBrandt at Hunter dot com

      #1; Fri, 04 Jan 2008 12:51:00 GMT
    • On 9 Mar 2007 18:35:53 -0800, "Wayne" <cqdigital.ms-access.todaysummary.com.volcanomail.com>

      wrote:

      In some applications tab controls contain subforms. If things get

      sluggish I typically only set the SourceObject once the user hits that

      particular tab.

      Otherwise: YMMV. Do some tests and see what your users' tolerance

      level is.

      -Tom.

      Quote:
      === Original Words ===

      >Is there a "best practice" maximum number of controls that can be

      >loaded on to a tab control before things start getting messy and

      >sluggish? I'm asking for a "best practice" maximum number across all

      >tabs and not the maximum number that is theoretically possible.

      >

      >I figure that trying to add lots of controls to lots of tabs must

      >affect performance at some point.

      >

      >Any help is appreciated.

      #2; Fri, 04 Jan 2008 12:52:00 GMT