String together different blocks of info using DLookup

[Dave14867]

I want to string together a few fields into 1 string for an address.



The fields are "Address", "City", "State", "Zip" & "Country"

How can I do that to put them into 1 text box named TxtAddress?

Thanks

Dave

[June7]

Really haven't given enough details.

How is DLookup involved? Usually better method than DLookup() to retrieve related data.

Are these fields in form or report RecordSource? Can do the concatenation in query then bind textbox to the constructed field.

Address & ", " & City & ", " & State & " " & Zip & " " & Country

[Dave14867]

June7,

I solved this by putting in another field in the table as a "Calculated" field and then used that in the DLookup, worked great.

Thanks

Dave