Concantenate two fields in a report

[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

 

[Rick Brandt]

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.

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.

 

[Steve G]

Yep...thanks, Rick, that was the problem.

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.

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.