Temp string in text box?

[Felgar]

I am attempting to write an autofill routine to make a best guess from a list of values that are stored in a table. (much like netscape will do for urls when you type them in the location bar).

I'm stumped because I don't know how to reference the data that is being typed in while they are still typing. I was going to make an OnKeyPress event to check each new letter as it is entered, and then generate a new list of items that match my first few letters. Unfortunately, the TextBox.Value item does not get updated until the change is recorded by Access when I move away from the field.

I need to check the value in the box as it is being typed. Any suggestions?

 

[LarryDeLaruelle]

Felgar:

You can do what you want a lot easier using a combo box.

Make sure to set the Auto Expand property to Yes.

HTH
Larry De Laruelle
larry1de@yahoo.com