By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,453 Members | 1,593 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,453 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..."

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:

Oct 23 '06 #2

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

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

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!

Oct 24 '06 #4

Post your reply

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