Value List to show TEXT behind value

[Guest]

OK, OK, so I broke the Second Commandment on DB Design and I used a value list.
There are 3 values - 1 Mail; 2 Phone; 3 Email

I want the my FORM to show the WORDS behind the value.
I've looked, and read, and tried numerous options, but to NO avail.

C'mon, even if I broke the commandment, there should be an escape clause for
me, don't you think?

Any workable solution?

 

[Guest]

Maybe someone has an easier way, but I would just change the value list to
remove the numbers & spaces, and then run an update query to convert existing
entries in the table where this is used from "1 Mail" to just "Mail", "2
Phone" to "2Phoneand "3 Email" to "Email"

If you want to maintain the numbers, run a query to convert existing entries
in the table where this is used from "1 Mail" to just "1", "2 Phone" to "2",
and "3 Email" to "3". When done, convert that field to a number (integer)
field. Now create a table with two fields for the info that was in the value
list:

MsgCode (Integer) MsgText (Text)
1 Mail
2 Phone
3 Email

Now bind column 1 with width 0 on the form where this selection is made.
This way, the user can select by the text but have the number stored in the
table.

 

[Lynn Trapp]

Eva,
It's never too late to fix your design. I'm not sure what the value list is
for, but you could easily create a table to store those values and, then,
use a combo box on a Form to lookup the value.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

OK, Gotcha!
Thanks Brian & Lynn.
You ROCK!
And I'll know better next time.