Bear of very little brain

[John Boote]

I have a simple db for recording quotations.

The data is entered via a form which contains general details of the quote,
this then has a subform to record the details of each item offered on that
particular quote. I use combo boxes on the subform to select a few variables
such as currency type, brand etc.

My question may be a silly one, but here goes....

Can I set the combo box on the subform to display like a text box when it
looses focus i.e. loose the arrow?

 

[Rick B]

If you did, that would mean that the user would have to actually go into
that field (give it focus) before they could see and use the arrow. That
does not seem very intuitive.

You could "lock" the field after the user found what they wanted, but that
would mean they'd have to close the form and reopen it to look for a new
item.

Not sure why either of these options would be desirable.

 

[SFatz]

Somewhere, sometime, someplace on the web I ran across someone's neat little
technique to do exactly what you want.
In essence, he/she placed a flat, borderless text box over the arrow portion
of the combo box.
Then he/she placed code in the GotFocus and LostFocus methods to set the
visibility of the text boxes off and on respectively.
You have to be sure that the background of the text box matches the
background of the combo box.

Wish I could remember better so I could give proper credit to the author,
but I hope this gives you some idea on one possible solution.