Software

Ask something
Discussion Locked

MS ACCESS - field values

0 helpful
3 replies

by qps

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a field that I've created a pull down menu for to choose a value among others. These are text values, (ex: What Color? Values are: Red, Blue, Green.

It works great. But when I go into the table, or when the report prints out, the value that actually shows up are numerical "1, 2, 3".

What do I have wrong that is making it to show the numerical value rather than what I actually want to show up???

3 replies

by bpaton

It sounds as if you are using a Combo Box and have selected the wrong Bound Column.
If you want to use a Combo Box for a dropdown list check the table it refers to and make that the Bound Column in properties is the correct one. Another approach would be to use a List Box and type in the Red, Blue, Green without referring to a table.

This discussion is closed to new replies.