Report prints primary Key instead of Description

  • Thread starter Thread starter Tommy T
  • Start date Start date
T

Tommy T

I have a report based on query... good so far right? Well I have 3 fields
that MAY or MAY NOT have text values in them so for clarity sake I created a
txtBoxState = field1 & ", " & field2 & ", " & field3. I know this is a text
string. When the report prints the primary key(numeric) instead of the
Description which is text (e.g. 3000, 4000, 7000). How can I create a
function or control field that will print = description1 & ", " &
description2 & ", " & description3 (e.g. Maine, Massachusetts, Michigan)?

Thanks in Advance.

Tommy T.
 
I have a report based on query... good so far right? Well I have 3 fields
that MAY or MAY NOT have text values in them so for clarity sake I created a
txtBoxState = field1 & ", " & field2 & ", " & field3. I know this is a text
string. When the report prints the primary key(numeric) instead of the
Description which is text (e.g. 3000, 4000, 7000). How can I create a
function or control field that will print = description1 & ", " &
description2 & ", " & description3 (e.g. Maine, Massachusetts, Michigan)?

Thanks in Advance.

Tommy T.
Click to expand...

Tommy,
Evidently your Text1,2,and 3 fields are combo boxes or LookUp fields
bound to the ID number, not to the column containing the text.

Make a query the recordsource for the report.
Include the tables and the column that make up Text1, Text2, etc.
instead of the current fields (Text1, etc.).

Then use that field in the report.

As a possible alternative, change your concatenated control to:
= field1.column(x) & ", " & field2.column(x) & ", " &
field3.column(x)
where x is the number of the column that contains the description.
Remember that combo boxes are zero based, so column(1) is really the
second column.
 
Back
Top