Concatation

[AndyShuter]

Hi,

Wondered if someone would help me with this this problem

=[Address1] & " " & [Address2] & " " & [Address3] & " " & [PostCode]

Is there away in which I can force a new line after each control so my address would appear:

29 Main Street
Palookaville
WF1 1AG

?

Thanks

 

[FoFa]

You need to insert a CHR10 and CHR13 usually (Carrige return & Line Feed).
You can use the VB constant vbcrlf (I think that is it's name) Like Address1 & vbcrlf & Address2 & vbcrlf etc.

 

[AndyShuter]

Sorry, I dont understand!

Heeeeelpppppp!

 

[cavscout]

=[Address1] & " " & [Address2] & " " & [Address3] & " " & [PostCode]

Is there away in which I can force a new line after each control so my address would appear:

29 Main Street
Palookaville
WF1 1AG

Replace your line of code above with this:

=[Address1] & vbCrlf & [Address2] & vbCrlf & [Address3] & vbCrlf & [PostCode]