Tom, i have inserted the combobox i am sending a demo off using the combobox
thanks for your help
"Rich Cooper" wrote in message
...
Tom, i understand the combobox and all, i am creating a report for a
client
and they are requested if it could be done by a textbox so i am trying
that
first....else i will do the combobox if all else fails

"Tom Ogilvy" wrote in message
...
I can only guess that you do not realize that if you use a combobox, set
the
range as the rowsource and set the property

ShowDropDownWhen to fmShowDropButtonWhenNever
Match Entry to FmMatchEntryComplete (the default)

that the dropdown will never display and you get the functionality you
have
right now plus the backspace and so forth are handled all with no
additional
code.

So, saying you won't use the Combobox sounds like you just don't know
this.

--
Regards,
Tom Ogilvy



"Rich Cooper" wrote in message
...
I guess my answer to your question unfortanually is yes

If you could help me that would be great otherwise i will keep on
reading
and looking till i get it to work using the textbox
"Tom Ogilvy" wrote in message
...
The functionality is built into a Combobox - it also supports the
backspace - so you want someone to help you reinvent the wheel?

--
Regards,
Tom Ogilvy

"Rich Cooper" wrote in message
...
Now that harald has helped me with the code for the autocomplete
coud
him
or
someone help me with the backspace key to work in the textbox

Thanks