New line on control

[Drenda]

Hi Can anyone help with the following which I am sure is an easy one

I have the following control on a form with the record source calculated as below

=" " & [Month] & " - " & [Year] & " Application For " & [Vendor Company Name] & " For Buildings " & [Building 1] & [Building 2] & [Building 3] & [Building 4] & [Building 5] & [Building 6] & [Building 7] & [Building 8] & [Building 9] & [Building 10] & [Building 11] & [Building 12]

This obviously displays text according to control values on the form. I would like to set a new line within the text so that it may read

=" " & [Month] & " - " & [Year] & " Application For " & [Vendor Company Name] & " For Buildings " & [Building 1] & [Building 2] - NEW LINE - & [Building 3] & [Building 4] & [Building 5] & [Building 6] & [Building 7] & [Building 8] & [Building 9] & [Building 10] & [Building 11] & [Building 12]

In Code I have been entering & vbCrLf & to create a new line but this doesn't work in the control

Thanks

 

[Remou]

You can use:

(Chr(13)+Chr(10))

Instead of:

vbCrLf

 

[Drenda]

Works a treat, many thanks