#Error concatenating strings in reports

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
 
D

Donna

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
 
K

Keldar

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

Donna

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