FilterLookup Property

Applies To

Form, Report.

Description

You can use the FilterLookup property to specify whether values appear in a bound text box control when using the Filter By Form window.

Setting

The FilterLookup property uses the following arguments.

Setting

Description

Visual Basic

Never

The field values aren’t displayed. You can specify whether the filtered records can contain Null values.

0

Database Default

(Default) The field values are displayed according to the settings in the Filter By Form Defaults section on the Option dialog box’s Edit/Find tab, available by clicking Options on the Tools menu.

1

Always

The field values are always displayed.

2


You can set the FilterLookup property in the text box’s property sheet, a macro, or using Visual Basic.

You can also set the FilterLookup property for a text box using the control’s default control style.

Remarks

If you find that a large list of field values take too long to display, you can limit the number of fields that will be displayed. To do this, clear the appropriate check box in the Filter By Form Defaults section on the Option dialog box’s Edit/Find tab, available by clicking Options on the Tools menu. If field lists aren’t displaying values correctly, you can increase the number in the Don’t Display Lists Where More Than This Number Of Records Read box so the setting is greater than or equal to the maximum number of records in any nonindexed field in the underlying source of records.

See Also

AllowFilters Property, ApplyFilter Action, ApplyFilter Event, ApplyFilter Method, Filter Event, Filter Property (Microsoft Office 95 Data Access Reference), Filter Property, OrderBy Property, OrderByOn Property.