Results 1 to 2 of 2

Thread: Table Filter

  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Table Filter

    Hi:

    In the table of the MS Access,

    when I apply "Filter by Form", go to the box and click, how can I make dropdown list to 100 rows, because the dropdown list only list 8 rows, then i need to scoll down to see other choices, I want it to show many rows when I click on it.

    Where can I change the setting? Thanks.

  2. #2
    Join Date
    Apr 2004
    Location
    Kingsland, Georgia
    Posts
    231
    If i understand you correctly, you need to switch to design view on the table, go to the field you're changing, and select the lookup tab. type will be combo bx, and list rows will be 8. you can change that to 20 or whatever. save the table, open it in datasheet form, and you're all set.

Posting Permissions

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