Combo box default value not working in form

[lscheer]

I have a simple combo box that uses a value list: Yes; No; Unknown. The default value is "Yes" in the field properties in the table and in the form. When I add a new record to the TABLE, "Yes" is dislpayed, however, when I add a new record to a form, it displays "-1" (note: the field is a TEXT data type).

Any ideas? I tried removing and re-adding the combo box to the form and it didn't help. Also, this only happens for new records (since I imported all my database objects into a new database)...all the old records display correctly.

 

[Kraj]

Did you check the formatting options for the field on the form? They will override formatting at the table level.

 

[lscheer]

Yes, I checked that already, there is no formatting on the field in the form or the table

 

[lscheer]

I'm still grappling with this problem...any other ideas?

 

[___]

You could try...

Me.YourCombo = "Yes"

when you add a new record.

 

[Kraj]

What if you changed it to a Yes/No field type instead? Would that work?