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.
 
Back
Top