Access Combining Access Data Fields

R

redlabel

Joined
Mar 31, 2006
Messages
1
Reaction score
0
Hi

Can someone please help me.

I have three address fields in an Access data table eg, ‘Add line1’, ‘Town’ and ‘City’ I need to combine these fields into a single address field in the same table eg ‘Address’.

It is important that each field appears below the other and that a hard carriage return is present after each line. Eg

Add line1
Town
City

I know that this means that only the first line of the address will appear in the access field eg ‘Add line1’ and the rest will be hidden. However it is important to have the address in this format for the program I am using.

Any help would be greatly appreciated.

Thanks

Redlabel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access - automatically add email extensions 0
Importing Text Files Into Access 1
Split data in field on character return 0
Access Automatically Send a notification email once a record is added 0
Access MS Access vba AfterUpdate coding question (hopefully a simple fix!) 0
making some fields mandatory in access data table 2
Emailing multiple reports in Access 0
Access Access Tick Box Calculation multiple records 0

Top