That is the way it is supposed to work. The ID is stored instead of the
text. But, if your combo is displaying the number and not the text then you
need to
1. go into the form in design view
2. click on the combo
3. Find the Number of Columns property and make sure it is set to 2.
4. Find the Column Width property and put 0";1.5" (use the appropriate
measurements for whatever fits).
The 0" tells it to hide that column, so if the first column is your ID
field, it would hide that one and then the 1.5" should display the text if
your combo's rowsource has something like
SELECT ID, Description FROM YourTableName ORDER BY Description;
in it (the names are made up, so your actual field names would be used).
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP
Tutorials at
http://www.btabdevelopment.com
__________________________________