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

  • Thread starter Thread starter Frances
  • Start date Start date
F

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?
 
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.
 
Thank you Allen, I have just checked that your suggestion works!

Allen Browne said:
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.

Frances said:
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?
Click to expand...
Click to expand...
 
Back
Top