combo box number not text

  • Thread starter Thread starter Chrissy
  • Start date Start date
C

Chrissy

Why does the number show in my combo box instead of the
affiliated text?

How do I remedy this?

Thanks.
C
 
Assuming that your "number" is the autonumber or unique
key of the lookup form, my guess is that is what you chose
to have displayed. It my well be that is what you need to
have as your bound column but to show the other data, you
need to change your lookup columns.

Check the properties of the combo box on the form.
Example:
I have an authors table. I want to store the AuthorID but
display the author's name. I have two columns in the
Authors table. AuthorID and AuthorName.

In your properties for the combo box, check these out.
For the simple example above here is what I would use

Column Count 2
Column Heads no (yes if you wish)
Column Widths 0";2"
Bound Column 1
List Rows 8 (it's the default but you can change it)
List Width 2" (so my whole author will fit)


hth

Lee T.
 
Lee,

Thanks so much. That took care of my combo box, now I
realize that on other forms that I view only the number
is returned. Of course, I want the text there too.

How do I do this for view only?

C
 
....and my forms have the same problem.

-----Original Message-----
OOPS!

I forgot I was in the report group, not forms. Sorry for
the previous goof!

The only way I have found to get around this is to build a
query that shows the data. Using my previous example in
my OOPS reply, I would make a query that had all my
book "stuff" and display the author's name from the
authors table.


.
Click to expand...
 
Ms. C

I am not sure what you mean for "view only". You can
lock the box so that the user can see the options but
cannot change it. If that is what you mean then go to the
combo box properties and set LOCKED to YES. Then they
cannot change the data.

hth

LT
 
Back
Top