Carriage Return

[Rita]

I've used Chr(13) & Chr(10) for envelopes to combine two lines of an address
(checking to see if there is a send line first).

I have a number of fields and the information varies greatly. I thought I
could just combine the following for a neater report. This does work, but I
would like a double space between fields. I tried just adding
&Chr(13)&Chr(10)&Chr(10), and that seemed to work, except I get a square box
displaying?

THANKS!

="Instructional: " & [Tips Instructional] & Chr(13) & Chr(10) & "Vocational:
" & [Tips Vocational] & Chr(13) & Chr(10) & "Behavioral: " & [Tips
Behavioral] & Chr(13) & Chr(10) & "Medical: " & [Tips Medical] & Chr(13) &
Chr(10) & "Dietary: " & [Tips Dietary] & Chr(13) & Chr(10) & "Personal Care:
" & [Tips Personal Care] & Chr(13) & Chr(10) & "Comments: " & [Tips Comments]

 

[Allen Browne]

You forgot the 2nd Chr(13):

="something" & Chr(13) & Chr(10) & Chr(13) & Chr(10) & ...

 

[Rita]

Thank you so much!

You forgot the 2nd Chr(13):

="something" & Chr(13) & Chr(10) & Chr(13) & Chr(10) & ...

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I've used Chr(13) & Chr(10) for envelopes to combine two lines of an
address
(checking to see if there is a send line first).

I have a number of fields and the information varies greatly. I thought I
could just combine the following for a neater report. This does work, but
I
would like a double space between fields. I tried just adding
&Chr(13)&Chr(10)&Chr(10), and that seemed to work, except I get a square
box
displaying?

THANKS!

="Instructional: " & [Tips Instructional] & Chr(13) & Chr(10) &
"Vocational:
" & [Tips Vocational] & Chr(13) & Chr(10) & "Behavioral: " & [Tips
Behavioral] & Chr(13) & Chr(10) & "Medical: " & [Tips Medical] & Chr(13) &
Chr(10) & "Dietary: " & [Tips Dietary] & Chr(13) & Chr(10) & "Personal
Care:
" & [Tips Personal Care] & Chr(13) & Chr(10) & "Comments: " & [Tips
Comments]