CODEWITHSUNDEEP
ms-accessreportconcatenation
SandPiper
SandPiper

Reputation: 2906

Concatenating a control source yields #Type! error

I have generated a report based on a query. I have a text box that I am trying to use to concatenate three of the values together for ease of readability. The fields are: [CREATOR], [TYPE], [SERIAL_NUM], and I want the output result to be something like:

Organization A, Spreadsheet, Copy 1

When I set the record source to just [CREATOR], it populates for every record. However, when I set the record source to

=[CREATOR] & ", " & [TYPE] & ", " & [SERIAL_NUM]

the final result for every record is #Type!

What am I doing wrong here?

Upvotes: 1

Views: 1180

Answers (1)

AVG
AVG

Reputation: 1462

Make sure that the name of the textbox is not Creator, type or serial_num

Upvotes: 3

Related Questions