New Line - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

New Line

Kevin Robertson

4 months ago

I have often thought that vbNewLine should have an Optional argument to determine how many new lines you want to add instead of having to type in vbNewLine multiple times.

See screenshot below.

	Kevin Robertson OP @Reply 4 months ago

	Alex Hedley @Reply 4 months ago
Nice idea

	Adam Schwanz @Reply 4 months ago
Nice Idea. I know I've chained a few vbnewlines together before and it makes the code look messy imo.

	Juan Rivera @Reply 4 months ago
I will cut n paste into my toolbox thanks for sharing. Richard add to code vault.... please

	Donald Blackwell @Reply 4 months ago
I just use the replace function in conjunction with the space function: Function NewLines(pLines As Long) As String NewLines = Replace(Space(pLines), " ", vbCrLf) End Function

	Sam Domino @Reply 4 months ago
Kevin Great idea! Definitely goes into my Access code repository!

	Richard Rost @Reply 4 months ago
Great idea. Mind if I stick it in the Code Vault?

	Kevin Robertson OP @Reply 4 months ago
Go for it.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View