combo box number not text

C

Chrissy

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

How do I remedy this?

Thanks.
C
 
L

Lee T.

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.
 
C

Chrissy

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
 
C

Chrissy

....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.


.
 
L

Lee T.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top