Default text in combobox

K

Kyle

I have a combobox. How do I setup this default message
"Select From List" appears on the combobox everytime a new
record is select. I tried to set the message in Default
Value but somehow not working.

Thanks.
 
R

Rick Brandt

Kyle said:
I have a combobox. How do I setup this default message
"Select From List" appears on the combobox everytime a new
record is select. I tried to set the message in Default
Value but somehow not working.

Place a TextBox on top of the ComboBox covering it exactly except for the
dropdown arrow.

Make it's ControlSource =Nz(ComboBoxFieldName,"Select From List")

In its GotFocus event use one line of code to change focus to the ComboBox and
then drop it down.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top