TextBox.FilterLookup property (Access)
Use the FilterLookup property to specify whether values appear in a bound text box control when using the Filter By Form or Server Filter By Form window. Read/write Byte.
Syntax
expression.FilterLookup
expression A variable that represents a TextBox object.
Remarks
The FilterLookup property uses the following settings.
| Setting | Visual Basic | Description |
|---|---|---|
| Never | 0 | The field values aren't displayed. You can specify whether the filtered records can contain null values. |
| Database Default | 1 | (Default) The field values are displayed according to the settings under Filter lookup options on the Current Database tab of the Access Options dialog box, available by choosing the Microsoft Office button, and then choosing Access Options. |
| Always | 2 | The field values are always displayed. |
You can also set the default for this property by setting a control's DefaultControl property in Visual Basic.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for