Bind a text box to a different field / expression Access 2007

[Frances]

In the ECDL advanced database course we often are asked to concatenate First
Name and Last Name fields in a report to a Full Name field.

Rather than add a new control to the report I had the idea of changing the
control source of the Last Name field by entering the expression =([First
Name]&" "&[Last Name]).
However I get errors:
Invalid Control Property: Control Source and
Circular Reference
Please can anyone tell me why I get this. Putting in an expression should
work according to
http://office.microsoft.com/en-us/access/HA100141171033.aspx?

 

[Allen Browne]

Change the Name property of the text box.

Access gets confused if the control has the same name as a field in the
report's source query, and yet it is bound to something else.

 

[Frances]

Thank you Allen, I have just checked that your suggestion works!

Change the Name property of the text box.

Access gets confused if the control has the same name as a field in the
report's source query, and yet it is bound to something else.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

In the ECDL advanced database course we often are asked to concatenate
First
Name and Last Name fields in a report to a Full Name field.

Rather than add a new control to the report I had the idea of changing the
control source of the Last Name field by entering the expression =([First
Name]&" "&[Last Name]).
However I get errors:
Invalid Control Property: Control Source and
Circular Reference
Please can anyone tell me why I get this. Putting in an expression should
work according to
http://office.microsoft.com/en-us/access/HA100141171033.aspx?