How do i set a default value in a combo box?

[Leo]

I have 10 combo boxes and I would like to set a default
value for all them. They are based on a table called
levolor

The default value I would like the combo box to be set to
is None. It is an entry in the table. I ahve tried
simply putting None in the default value area for that
box in my form, but no such luck. Thank you.

 

[alan fisher]

It should work. Did you make sure to put quotes around the
word None.

 

[Leo]

yeah it does but no such luck! It doesn't display none

 

[Bruce M. Thompson]

I have 10 combo boxes and I would like to set a default

value for all them. They are based on a table called
levolor

The default value I would like the combo box to be set to
is None. It is an entry in the table. I ahve tried
simply putting None in the default value area for that
box in my form, but no such luck. Thank you.

Does the combo box have more than one column defined? If the bound column is an
ID field, then that is the value you want to set as the default value for the
combo box.

 

[Tim Ferguson]

I have 10 combo boxes and I would like to set a default
value for all them. They are based on a table called
levolor

I strongly suspect a Design Problem here, and that the ten recurring fields
would be better modelled as ten records in a LevocolorComboValues table,
presumably with some kind of Listbox or Subform control.

The default value I would like the combo box to be set to
is None. It is an entry in the table. I ahve tried
simply putting None in the default value area for that
box in my form, but no such luck. Thank you.

If the combo boxes are the spawn of the detested Lookup Field Wizard, then
you have a lot of unpicking to do. You need to find the (hidden) ID value
for the entry "none" and then set the Default Value to that number. This is
just one of the reasons why the LFW is so horrid -- the code for it is full
of "666" errors...


All the best


Tim F