Line feed in string

M

Margaret M

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
 
M

M.L. Sco Scofield

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
 
M

MargaretM

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
 
M

M.L. Sco Scofield

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
 

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

Outlook 365 overriding formatting choices 0
Select Text to End of Footnote 9
embedded character 2
Using CRLF or some other f of NEWLINE Character in an outlook rules filter 0
vbCrLf problem vs Excel 2
Autonumber field in Excel that behaves the same as Access 0
Request help determining line length and end of line carriage returnsthrough document 0
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1

Top