Results 1 to 2 of 2

Thread: Table Filter

  1. #1
    Join Date
    Sep 2005

    Unanswered: Table Filter


    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
    Kingsland, Georgia
    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