>(Wish I had a better title)
>
>I have an existing form with a combobox - RowSourceType=1-Value and RowSource=Unknown,Yes,No - it matches a one character field in a table and correctly puts the first character (of the selected RowSource word) into the table.
>
>My customer wants a quick fix to have it display the full word - not just the single character - when updating a record.
Try (All combo items are at their defaults):
With This
.AddListItem("Unknown",1,1)
.AddListItem("U",1,2)
.AddListItem("Yes",2,1)
.AddListItem("Y",2,2)
.AddListItem("No",3,1)
.AddListItem("N",3,2)
.BoundColumn=2
.ControlSource = "myAlias.myField"
.Style = 2
Endwith
Cetin