text formatting

[Guest]

Hi


Here’s another question. I have the following report header the field
[problem] is variable length

="Guest With " & [problem] & " Injuries Between
" & Format$([Date1],"mmmm dd"", ""yyyy",0,0) & " and " &
Format$([Date2],"mmmm dd"", ""yyyy",0,0)

My question is. Is there a way to put a carriage return in right after the
“Between†so I can keep the text lined up the way I want it the spaces I
have in there don’t do the job.


Thanks for the help in advance
Chuck

 

[SusanV]

"First line of Text" & vbCrLf & "Next line of text"

 

[Guest]

Thank you!!!

"First line of Text" & vbCrLf & "Next line of text"

--
hth,
SusanV

Hi


Here's another question. I have the following report header the field
[problem] is variable length

="Guest With " & [problem] & " Injuries Between
" & Format$([Date1],"mmmm dd"", ""yyyy",0,0) & " and " &
Format$([Date2],"mmmm dd"", ""yyyy",0,0)

My question is. Is there a way to put a carriage return in right after
the
"Between" so I can keep the text lined up the way I want it the spaces I
have in there don't do the job.


Thanks for the help in advance
Chuck

 

[SusanV]

You're very welcome!

Thank you!!!

"First line of Text" & vbCrLf & "Next line of text"

--
hth,
SusanV

Hi


Here's another question. I have the following report header the field
[problem] is variable length

="Guest With " & [problem] & " Injuries Between
" & Format$([Date1],"mmmm dd"", ""yyyy",0,0) & " and " &
Format$([Date2],"mmmm dd"", ""yyyy",0,0)

My question is. Is there a way to put a carriage return in right
after
the
"Between" so I can keep the text lined up the way I want it the spaces
I
have in there don't do the job.


Thanks for the help in advance
Chuck