ACC: Filter By Selection Fails in Value-List-Filled Combo BoxID: Q139042
|
Novice: Requires knowledge of the user interface on single-user computers.
If you highlight part of the text in the text box portion of a combo box
and click Filter By Selection on the toolbar, no records are returned.
The combo box is filled with a value list and the bound column is not the first displayed column in the list. When you highlight just part of the text in the text box portion of a combo box, Microsoft Access cannot match the text highlighted in the displayed column with the data from the bound column that is actually stored in the underlying table's field.
To work around this behavior, display the bound column as the first visible column in the combo box list, or fill the combo box with values from a table or query.
Field Name: Gender
Data Type : Text
Field Size: 1
Display Control: combo box
RowSourceType: Value List
RowSource: Male;M;Female;F
BoundColumn: 2
ColumnCount: 2
ColumnWidths: ;0
ListRows: 2
Like "*male"
Additional query words: fbf fbs
Keywords : FmsOthr
Version : 7.0 97
Platform : WINDOWS
Issue type : kbprb
Last Reviewed: April 30, 1999