Concantenate two fields in a report

  • Thread starter Thread starter Steve G
  • Start date Start date
S

Steve G

Hi All:

Access2002

I am using this code in the control source to try to concantenate two fields
in a report:

=([FirstName] & " " & [lastName])

However, all this does is produce an error.

Any help would be appreciated, as always

Steve G
 
Steve G said:
Hi All:

Access2002

I am using this code in the control source to try to concantenate two fields
in a report:

=([FirstName] & " " & [lastName])

However, all this does is produce an error.
Click to expand...

Make sure that the name of the Control itself is neither "FirstName" nor "LastName".
When a control's own name appears in its ControlSource expression is causes a
circular reference error.
 
Yep...thanks, Rick, that was the problem.

Steve G

Rick Brandt said:
Steve G said:
Hi All:

Access2002

I am using this code in the control source to try to concantenate two fields
in a report:

=([FirstName] & " " & [lastName])

However, all this does is produce an error.
Click to expand...

Make sure that the name of the Control itself is neither "FirstName" nor "LastName".
When a control's own name appears in its ControlSource expression is causes a
circular reference error.
Click to expand...
 
Back
Top