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.
Click to expand...

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.
 
Top