Formatting Text from a query

[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

 

[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]

 

[DaveG]

Douglas J. Steele wrote:

Thank you Douglas that was just what I needed