Combo Boxes - ID # entering into Table And not Text

[david.isaacks]

I have several combo boxes on a Access form and they work fine except
then enter the ID number next to the text into the table and not the
text. The Text shows up in the drop down and not hte ID. How do I get
the combo box to enter what text I have into the table and not the
associated ID #?

David

[Keith Wilby]

<da***********@mail.va.gov> wrote in message
news:11**********************@j55g2000cwa.googlegr oups.com...

I have several combo boxes on a Access form and they work fine except
then enter the ID number next to the text into the table and not the
text. The Text shows up in the drop down and not hte ID. How do I get
the combo box to enter what text I have into the table and not the
associated ID #?

Change the bound column to "2" - but why would you want to make this change?
It's a perfectly sensible way to store data and to change it might cause
unwanted file size bloat and would render your ID redundant. You could
always just make the ID column width 0 so that you never see it.

Regards,
Keith.
www.keithwilby.com

[david.isaacks]

Well I need to export some of the data to excel in the future, and the
numbers won't mean much to the person I am giving the data too.

Thanks, I new it was something easy. - David

[Rick Wannall]

Keep your data normalized, which it seems to be if you're storing an ID that
points to a row in a "lookup" table. That's the right way to do things.

Use a query for the export. Join your data table to the "lookup" tables and
export data from the query. You don't have to include the ID columns in the
query. Just link to a referenced table, pull the text field from it down to
the query design grid, and export the text.

<da***********@mail.va.gov> wrote in message
news:11*********************@j33g2000cwa.googlegro ups.com...

Well I need to export some of the data to excel in the future, and the
numbers won't mean much to the person I am giving the data too.

Thanks, I new it was something easy. - David

[david.isaacks]

Great That make perfect. I see what you are talking about now. Thanks -
David