Use predictive text as you type into a text box

[Typicalalex1]

I have a text box on one of my forms and when you type in the text box it displays the results of the search into a subform. Is there a way to predict what is going to be typed in the text box like in a combo box.
I cant use a combo box because there are more than 1 of the same item in the list.

Thanks

 

[Poppa Smurf]

For a text box there is no property called Auto Expand. In a combo box there is an Auto Expand property that expands or predicts the text as you type each character.

 

[Typicalalex1]

Ok thanks, in that case, is there anyway of hiding the arrow on the combo box so it looks like a text box?

 

[JANR]

From searching this forum: http://www.access-programmers.co.uk/forums/showthread.php?t=172447&highlight=hide+arrow+combobox

JR

 

[missinglinq]

I cant use a combo box because there are more than 1 of the same item in the list.

You can fix this by using DISTINCT in the query your combobox is based on.

Allen Browne also has a hack that imitates the AutoExpand property in atextbox:

http://allenbrowne.com/AppFindAsUType.html