By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,986 Members | 2,042 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,986 IT Pros & Developers. It's quick & easy.

Line Break in a text box?

P: 14
Hi all,

I know when I do data entry, I can force a line break in a text box by using Control & Enter. I'm trying to insert a line break in a field (that behaves like Control Enter) from VB.

Anyone know the command for this?

Here's what I want to do:

rst2("Change") = rst2("Change") & **LINE BREAK *** & "Autopropagated Change to..."

Thanks!
Lea Ann
Oct 23 '06 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 1,892
Not clear what you mean but this will give you a new line:

vbCrLf
Oct 23 '06 #2

NeoPa
Expert Mod 15k+
P: 31,347
I think AricC has what you want. It should read :-

Expand|Select|Wrap|Line Numbers
  1. rst2("Change") = rst2("Change") & vbCrLf & "Autopropagated Change to..."
or

Expand|Select|Wrap|Line Numbers
  1. rst2("Change") = rst2("Change") & vbCrLf & _
  2.         "Autopropagated Change to..."
for clarity.
Oct 24 '06 #3

P: 14
Thank you! This is exactly it!

LAM
Oct 24 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.