Reports pulling in Primary Key

I have my combo box bound to a name column in all, table, form and query, but
when I run a report it pulls only the prim key # for that column. How do I
get it to pull the name?

If the Combo RowSource includes two fields
Select Field1 , Field2 From TableNAme

And you want the combo to display the value in field2, you need to set the
column width of the combo not to display the first column

0 cm; 3 cm

--
Good Luck
BS"D


"ewest2112veneer" wrote:

I have my combo box bound to a name column in all, table, form and query, but
when I run a report it pulls only the prim key # for that column. How do I
get it to pull the name?

Good evening Ofer,

Thanks, I knew something had to do with column widths.

I have my Field Names, ie Description in Combo Boxes, and everything is
working well, thanks to some much needed help. Here is what I would also like
to do in my Report and have not been able to do as of yet. I have a
Description Header and a Description Footer. In the Description Footer, I
would like to have a phrase which says something like ="Summary of" &
[Description]&": " My problem is that since the FieldName Description is in
a Combo Box, I can't seem to do that without using a label for the "Summary
of" portion then placing Description in the Combo Box quite close by the
Label and then adding another Label for the ":"

Is there a way to do that without having to redo my tables, queries, forms,
etc?

Also, may I have a table without a Primary Key and have it function
correctly as a Lookup Table?

"Ofer Cohen" wrote:

If the Combo RowSource includes two fields
Select Field1 , Field2 From TableNAme

And you want the combo to display the value in field2, you need to set the
column width of the combo not to display the first column

0 cm; 3 cm

--
Good Luck
BS"D


"ewest2112veneer" wrote:

I have my combo box bound to a name column in all, table, form and query, but
when I run a report it pulls only the prim key # for that column. How do I
get it to pull the name?