Concatenation returns #Name?

[Guest]

Hi,
I am trying to display a concatenated address on form and report fields
using the following:
[JAddress] & Chr(13) & Chr(10) & [JSuburb] & Chr(13) & Chr(10) & [JState] &
" " & [JPostcode]

However, this returns #Name? error. The control does not have the same name
as any of the variables. I have also tried variations on this including using
+ instead of & and Chr$13 and Chrr$10.

The weird thing is that this was working and displaying the correct
information, now it isn't.

Any ideas?
Thanks
Kirra

 

[Rick Brandt]

Hi,
I am trying to display a concatenated address on form and report fields
using the following:
[JAddress] & Chr(13) & Chr(10) & [JSuburb] & Chr(13) & Chr(10) & [JState] &
" " & [JPostcode]

However, this returns #Name? error. The control does not have the same name
as any of the variables. I have also tried variations on this including using
+ instead of & and Chr$13 and Chrr$10.

The weird thing is that this was working and displaying the correct
information, now it isn't.

If you are entering that directly into the ControlSource of a control then it
needs an equals sign at the front. Do you have that?