Formatting Text from a query

D

DaveG

Hi all

I have a query that brings together many address feilds.

Address: Customer.Address1 & " " & [Address2] & " " & [PostCode] & " "
& [City]

I display this into a text box which works fine. Now I would like to
format the text box so that there are seperate lines for

Address1
Address2
PostCode & City

I have tried adding things like vbcrlf into the query with no joy.

Is this possible in the query or must I minipulate the text with VBA
then post it to the textbox.

Thanks in advance
 
D

Douglas J. Steele

vbCrLf is a VBA constant that queries know nothing about.

Try:

Address: Customer.Address1 & Chr(13) & Chr(10) & [Address2] & Chr(13) &
Chr(10) & [PostCode] & " " & [City]
 

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

Populating textbox with more than one row of text 1
Mailing address block: sorting 1 row to columns 1
Access 2007 how do I delete/separate a label from its text box? 4
How can I quickly change the table name in a query? 15
Remove certain characters from a text string 6
How to update a text box from a 2nd table 1
Remove Null fields in a report in address 2
Problems using Docmd.RunSQL 6

Top