concatenate fields in access report = #Type!

[angerplea]

I have two address fields that I want to tack together due to space contraints.

=([add1] & " " & [add2])

Seems to work in a query but not report?

I've tried a few other ways but no luck. Any feedback would be appriciated.

:banghead:

Thx

 

[CJ_London]

Not a lot to go on - when you say it doesn't work, what does that mean? - it produces a blank or an error message? If you get an error, what is the error message and code?

As code it looks fine - I presume the two fields do exist? and you have this in the control source?

You don't need the round brackets but having them won't make a difference

Sorry just realised error message in title. The error message is telling you that something is the wrong type so are add1 and add2 to the right type - i.e. text or number

 

[Pat Hartman]

Make sure that the control name didn't get left at addr1 or addr2 or anything else that duplicates the name of a field in the controlSource. Just rename the control to
txtAddr1Addr2

 

[angerplea]

Not a lot to go on - when you say it doesn't work, what does that mean? - it produces a blank or an error message? If you get an error, what is the error message and code?

As code it looks fine - I presume the two fields do exist? and you have this in the control source?

You don't need the round brackets but having them won't make a difference

Sorry just realised error message in title. The error message is telling you that something is the wrong type so are add1 and add2 to the right type - i.e. text or number

Both fields are formatted as text in a linked view and that does not appear to change along the way to the report. I ended up combining the two fields within the header query that feeds into the report which solves the problem.

I agree formatting is most likely the issue, but I don't see where. No big deal tho.