Access Programming

[Guest]

Dear Sir/Madam

Let i have a combo box..and inside there r three values ..apple mango and
oranges..in the combo i have given short names..like apl ,mag and org..but i
want that in database it shud store full word..

so please tell me..how to do it ??

thanking you

 

[Al Camp]

Husain,
Make the first column Apples, Mango, and Oranges.
Make the second column Apl, Mag, Org.
Bind the combo to your table field.
In the combo properties...
ColumnCount = 2
ColumnWidths = 0"; 1"
ListWidth = 1"
The combo will show Apl, Mag, and Org as possible selections. After selection, the
combo will still show
you choice as Apl or Mag or Org... but... in reality, the value stored in the bound field
will be Apples or Mangos or Oranges.

To check this out, make a few choices on different records, and then view the table
itself. Even though the form shows Apl, Mag, or Org,
the table will actaully store Apples... etc...