combo boxes

[Guest]

hi. I'm using a combo box to select a language for each new record. How can
I set the combo box so that when it is clicked it highlights "English" by
default. The Languages are in alphabetical order at present.

Thanks

 

[Guest]

You can set the Combo's Default property to "English", that way not only that
"English" will be selected when the user press the combo, he won't have to.

 

[Guest]

I have tried this by putting "English" in the default value property under
properties but it isn't working. Would it be better to do it using code?

 

[Guest]

If the combo RowSource contain Number and string, and you store the number in
the table, set the default to the number that represent English and not the
word.

The default will work only for new records, not with records that already
exist but the combo is empty, is that the case you are talking about?

 

[Guest]

Thanks. That is exactly what I was after. In the case of editing records
with a blank combo box is it possible to just highlight English as a default
when combo is clicked?

 

[Guest]

Try this
On the MouseDown event of the combo, write the code

If IsNull(Me.ComboName) Then
Me.ComboName.Text = "English"
End If

 

[Guest]

thanks. it doesn't work but it's not an essential part of my form. The user
will just have to scroll a little bit. thanks for your help

 

[Guest]

Another option will be to create an extra field in the combo, that will make
English to be the first word, and sort it by name.
Something like

Select language From TableName
Order By IIf([language]="English",1,2) , [language]