By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,573 Members | 903 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,573 IT Pros & Developers. It's quick & easy.

Combo Boxes - ID # entering into Table And not Text

P: n/a
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

May 24 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
<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
May 24 '06 #2

P: n/a
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

May 24 '06 #3

P: n/a
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

May 24 '06 #4

P: n/a
Great That make perfect. I see what you are talking about now. Thanks -
David

May 24 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.