Line feed in string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to insert a carriage return / line feed in a text string and I
can't seem to find which character or ASCII code to use in my VBA code.

Thanks,

Margaret
 
Chr$(13) & Chr$(10)

or

vbCrLf

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Communications Director www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Thanks - I knew it was simple but it was one of those things I couldn't find
in a reference book. I really appreciate it. Thanks again
 
You're most welcome.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Back
Top