Concatination

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

Can anyone tell me what I am doing wrong. I have a
calculated text box with the following inside:

= [Contact Name] + & vbCrLf &[Landlords Name] & vbCrLf &
[Address1] & vbCrLf & [Address2] + vbCrlf & [Town] & ", "
& [County] & " " & [Postcode]

However Access puts square brackets around all the vBCrLf
parts.

I am trying to create a text box which displays several
fields together with a line feed inbetween each field,
and if a field is empty it doesn't leave a space.

Thanks in Advance
 
vbCrLf is a Visual Basic constant that can only be used in code.

Replace it with:
Chr(13) & Chr(10)
which gives you a carriage return character and a line feed character.
 

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

line feed not showing in report 4
Printing Addresses 2
Concatination (I think?) 4
Docmd Send Object - multiple CC fields from a form 3
Email using CDONTS 1
Formatting Text from a query 2
How do I determine if a element exists in an xml file? 7
Supressing the contents of a field if its empty 3

Back
Top