Separating text by carriage return

[Contro]

Hi guys!

I was wondering if you could help me. Basically, I'm wanting to do a
sort of auto complete in an access text box, with the help of visual
basic, where the user will put in, for example, m, and that will change
to Mathematics; I know how to do this part, but I want to be able to do
this for multiple entries, each of which are separated by a carrage
return.

For instance:

m
e
h

would become, upon each character return

Mathematics
English
History

So that after "m" is input and the return key is pressed, m will change
to Mathematics, and so on with every return that is entered after a
letter is input (which is recognised, obviously).

I know how to do this in visual basic for a text box if it just had one
entry in it (such as changing "m" to "Mathematics"), but I do not know
how to do it each time a return key is pressed for multiple items.

Any help on this would be hugely appreciated!

Thanks in advance,
Contro.

[pietlinden]

use a combobox, set limit to list to true in the properties of the
combobox, and it should do it for you.

[Contro]

pi********@hotmail.com wrote:

use a combobox, set limit to list to true in the properties of the
combobox, and it should do it for you.

Thanks for you reply.

This solution would not be ideal, as there may be many different
subjects to choose from as well as many being of similar description
(Domestic Science A, Domestic Science B, Art and Design: 3D Studies,
Art and Design: Drawing and Painting etc), as well as the user needing
to sometimes enter values that are not listed.

Please keep the help coming!

Contro.