Combo Box Default Value

[Guest]

Hello all,

I have a bound Combo box with a value list as the row source. The drop-down
works fine but my default value doesn't appear in form view. I tried entering
the default value several different ways but to no avail.

If I change the Combo box to a Text box then the default value appears.

Why won't the default value appear in a Combo.

 

[Jeff Conrad]

in message:

Hello all,

I have a bound Combo box with a value list as the row source. The drop-down
works fine but my default value doesn't appear in form view. I tried entering
the default value several different ways but to no avail.

If I change the Combo box to a Text box then the default value appears.

Why won't the default value appear in a Combo.

If the combo box has more than one column and you have hidden the
first column, the Default Value must be something that exists in the first
non-hidden column.

For example, suppose you have a two column combo box with the following
as its Row Source:

0;"First";1;"Second";2;"Third";3;"Fourth"

You've also set the Column Widths to:

0";1"

So the user only sees the text strings.

The first column is the bound column and will get saved with the record.
If you enter "First" as the Default Value, the form will not show anything
as the default. If however, you enter 0 as the Default Value you will observe
that the combo box correctly displays "First" as the default.

 

[Guest]

Jeff,

Thanks a million, it works just as you said it would.

 

[Jeff Conrad]

in message:

Jeff,

Thanks a million, it works just as you said it would.

You're welcome, glad to help.
Good luck with your project.