Add Textboxes together to create long address?

[spacepro]

I am trying to add values together to create a long address.

I have 5 textboxes for
Address
Address 1
Town
Country
PostCode

I have created another textbox and bound it to longaddress in the table and put the following in the defaultvalue entry:

=[Customer_Address]+[Customer_Address1] etc etc

This does not work.
Any ideas or won't it be possible due to the 255 chars limit.

Many Thanks
Andy

 

[jfgambit]

Just out of curiousity, why would you want all the information in one field??

You can use the following on the On Click event of a command button:

Me.FieldName = me.Address & " " & me.Address1 & " " & me.City & " " & me.State & " " & me.Zipcode


HTH

 

[chrismcbride]

Try

=[Customer_Address] & " " & [Customer_Address1] etc etc

Chris

 

[KevinM]

You don't store this 'long address' in the table.
Instead use an expression in a query...

LongAddress:[Address1] & " " & [Address2] etc etc

or...

LongAddress:[Address1] & ", " & [Address2] etc etc

 

[spacepro]

Thanks All

Kevinm & Chrismcbride thanks for the suggestion

jfgambit:

I need to store this info in a query or table because it will be exported into excel then imported into third party software for routing purposes.

The software will only take in one column with all of the address details.

Many thanks Guys
Andy

 

[Pat Hartman]

You don't need to store the concatenated field since you can export a query rather than the table.