AutoComplete textbox - Combobox

[Michael]

Hello

I would like to use a combo box with no arrow button.

In my application, all combo boxes are set to limit to
list.

This field is now a text box for the users to enter. But I
would like them to be able to partialy write and select
from previous entries (from a history table).

I dont want the users to be confused by thinking that they
have to choose from the list. They are free to enter any
text in that place, an new text will be added to the
history table.

So this is why I would like to always hide the arrow
button on the combo box.

I tried masking it with a rectangle, but when the combo
box as
focus, then arrow button reappears.

Are there any other solution?
How about create a custom control combo box with no button?
Is it hard?

The Combobox would than be an AutoComplete textbox, and on
double cliking the textbox, the list would dropdown.

It would be placed in an Access 2000 Continuous Form.

Thanks,

Michael

 

[GVaught]

Why not just create the Combo box with the present choices and then add code
under the combo boxes' Not In List event. This will allow the user to either
pick from those available or as soon as they enter a value not listed in the
combo box, the 'Not in List' will allow them to add it for future use.

 

[Michael]

I intended to use a combobox and set the 'limit to list'
to 'No' and add code accordingly.

BUT:

I want arrow button on the combo box to be hidden always.

I dont want the users to be confused by thinking that they
have to choose from the list. They are free to enter any
text in that place, an new text will be added to the
history table.

So this is why I would like to always hide the arrow
button on the combo box.

I tried masking it with a rectangle, but when the combo
box as focus, then arrow button reappears.

Thanks,

Michael