Predictive text in a Filter

[Goopie]

When I filter one form (Suppiers) the predictive function works ie if I key
'Pr' it fills in the first word starting with those two letters - say
'Predict'.
However on another of my forms (Clients) this feature doesn't work and I
can't work out why.
Can anyone suggest a possible cause and solution?
And btw , what is feature called exactly? I've tried numerous descriptions
in help like predictive text and autofill but cant quite nail the right name
for this very helpful feature.

Thanks for any help

 

[tina]

if you're talking about a combobox control, the property is AutoExpand.

hth

 

[Jeanette Cunningham]

Hi Goopie,
it's called Search as you type or find as you type.
It filters a form with each keystroke.
This works well using a combo box. Is this what you are doing?
It is possible to write code that will find matches as a user types text
into a textbox.
Perhaps this is what you are doing?
Post your code that doesn't work and we can suggest what to do.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Goopie]

Thanks for the reply.
The search as you type is usually set up by the database designer with code.
I'm referring to the inbuilt feature of Access. In a general form, when you
perform a filter on a field, Access will fill in the first entry from the
table as you type, like the example I quoted.
So - in a general form of say Clients, on a find you type Dia and Access
will fill in Dianne if thats the first entry with Dia. Its useful if you dont
know the spelling of a name.
However as I said this feature works in one form and not the Clients form.
Thats what I dont understand.
I hope this clarifies my question.

 

[Jeanette Cunningham]

The built in feature is just not as good as something that done by writing
code.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia