Combo and List Box Performance

Most of us use combo and list boxes frequently, so it's important to make them as efficient as possible. Here are a few tips for creating the most efficient combo and list boxes:

  • Include only those fields that you really need--extraneous fields use resources unnecessarily.
  • Set the Auto Expand setting to No if it doesn't matter what item Access displays in the text box portion of your combo box.
  • Don't hide columns using the Column Widths property of 0 unless it's absolutely necessary.
  • Treat list items as text whenever possible, because numerical data can slow things down.
If you follow these few rules, your combo and list boxes should perform exceptionally well.

Access Index

Main Index

Search RD Techbase