#Error concatenating strings in reports

  • Thread starter Thread starter Keldar
  • Start date Start date
K

Keldar

I am having difficulty concatenating strings within a report.

I am trying to report Department Name followed by the Head of Department in
brackets thus

=[DepartmentDescription] & " (" & [DeptHeadFName] & " " & [DeptHeadLName] &
")"

This is in a textbox on the report and all I get in report view is #Error.

I can happily report the individual pieces f text in separate boxes, but not
concatenated together. What mystifies me more is that there are other
occaisions where I have done exactly this without a problem.

Can anybody shed any light
 
It's likely that the NAME of your text box is either DepartmentDescription, DeptHeadFName, or DeptHeadLName. If so, rename the NAME of your text box to something else; ie, txtDepartmentDescription. This should take care of it


----- Keldar wrote: ----

I am having difficulty concatenating strings within a report

I am trying to report Department Name followed by the Head of Department i
brackets thu

=[DepartmentDescription] & " (" & [DeptHeadFName] & " " & [DeptHeadLName]
")

This is in a textbox on the report and all I get in report view is #Error

I can happily report the individual pieces f text in separate boxes, but no
concatenated together. What mystifies me more is that there are othe
occaisions where I have done exactly this without a problem

Can anybody shed any ligh
 
Great... Thanks....

If only you knew how long that problem has been haunting me... it is jus
tthat I use access so infrequently I have usually just worked around it by
doing the concat in the query.

Many Thanks
Ian

Donna said:
It's likely that the NAME of your text box is either
Click to expand...
DepartmentDescription, DeptHeadFName, or DeptHeadLName. If so, rename the
NAME of your text box to something else; ie, txtDepartmentDescription. This
should take care of it.
----- Keldar wrote: -----

I am having difficulty concatenating strings within a report.

I am trying to report Department Name followed by the Head of Department in
brackets thus

=[DepartmentDescription] & " (" & [DeptHeadFName] & " " & [DeptHeadLName] &
")"

This is in a textbox on the report and all I get in report view is #Error.

I can happily report the individual pieces f text in separate boxes, but not
concatenated together. What mystifies me more is that there are other
occaisions where I have done exactly this without a problem.

Can anybody shed any light
Click to expand...
 
Very much understood

I went through the same torture myself. Someone on this forum helped me out. It's nice to be able to reciprocate.
 
Back
Top