Autocomplete textboxes

mashimaro

Can I have autocomplete textboxes in Access 2002?

I have a table of my customer names, and everytime they made a transaction, I will insert to my database. Now, I want when I type the customer name in the input form, it can autocomplete or autosuggest for me the appropriate customer names. How can I do that with Access2002?

missinglinq

To do this in any version of Access would be way too processor intense, and would slow the app down to a crawl! Each time you entered a character you'd have to check the textbox's content against the appropriate table. This kind of thing can be done much more easily with a combobox with the AutoExpand property set to Yes. You base the combobox on the customer name, then include the other fields you want to place on your form. When the user starts to enter the name in the combobox, it will autocomplete, and when you select the proper name, the other fields can be filled in.

Linq ;0)>

mashimaro

Quote:

Originally Posted by missinglinq

To do this in any version of Access would be way too processor intense, and would slow the app down to a crawl! Each time you entered a character you'd have to check the textbox's content against the appropriate table. This kind of thing can be done much more easily with a combobox with the AutoExpand property set to Yes. You base the combobox on the customer name, then include the other fields you want to place on your form. When the user starts to enter the name in the combobox, it will autocomplete, and when you select the proper name, the other fields can be filled in.

Linq ;0)>

Thanks Linq for the tips. It's really help a lot ^^ Sorry for my late reply, has been fighting with office work :( Again, thanks a lot ;)

missinglinq

Been there, done that!

Linq ;0)>

Autocomplete textboxes

re: Autocomplete textboxes

re: Autocomplete textboxes

re: Autocomplete textboxes

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about