>>(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
Bob,
Fabio's is much better, use that one.
Cetin