How To Insert A List Into A Listbox In Microsoft Access 2007?

Tags: , , , ,

3 Responses to “How To Insert A List Into A Listbox In Microsoft Access 2007?”

  1. Nahee_En says:

    There are many ways to put entries into a list box. Most list boxes are bound to a Lookup field. To set the properties for a list box in a form, then do the following:
    1. In the RowSourceType property box, do one of the following:
    • In an Access database, to show values from a table or query, or results of an SQL statement, select Table/Query.
    • In an Access project, to show values from a table or query, or results of an SQL statement, select Table/View/StoredProc.
    • To show a fixed list of values, select Value List.
    • To show a list of fields in a table or query, select Field List.
    2. In the RowSource box, do one of the following:
    • Select a table or query containing the values or field names that you want to appear in the list box.
    • Type a list of fixed values and separate each item with a semicolon (;).
    • Type an SQL statement or click the Build button to open the Query Builder.
    3. If you want more than one column to appear in the control, click the ColumnCount property box and type the number of columns you want.
    There are about a dozen other ways I could list for filling a list box, and there is not enough room here to document them all.

  2. Bind the list box to a table or query by setting the row source of the list box. Then set the column widths and column count properties. You can also use the wizard to this by making sure the wizard button is pressed on the toolbox and then selecting the list box control.
    The #1 solution for total Access Masteryhttp://access-databases.com/ms-access-tu…

Leave a Reply

Spam Protection by WP-SpamFree

0 Blogs linking to this article »