Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / September 2006

Tip: Looking for answers? Try searching our database.

Putting a return within text

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Newforms - 19 Sep 2006 03:56 GMT
I really need some help with this one, I have tried a few options but
not managed to get any to work. I need to insert a carriage return into
some text automatically entered by a form I have created so that
instead of being on one line it is seperated into paragraphs.

Here is the code I need to alter:

If OptionButton1.Value = True Then
   pleasenote = "you need to have had your home loan running with us
for a minimum of one year. Once your home loan has been in place for
the required time, we'll be pleased to reconsider your application."

So that the text will appear like this:

you need to have had your home loan running with us for a minimum of
one year.

Once your home loan has been in place for the required time, we'll be
pleased to reconsider your application."

Any suggestions? Guessing it will be a simple solution, well hoping
more, I am new to all this!

Thanks, Jon
Cindy M. - 19 Sep 2006 12:26 GMT
Hi Newforms,

vbCR is the command to insert a new paragraph into a Word document. So
you'd do this

"Some text" & vbCR & "Text for the next paragraph." & VbCR & "Another new
paragraph."

I see you put extra vertical space between the paragraphs in your
example. You can format Word paragraphs with SpaceBefore and/or
SpaceAfter. This is the "preferable" way to get extra space. The
alternate method is to insert more than one vbCR.

> I really need some help with this one, I have tried a few options but
> not managed to get any to work. I need to insert a carriage return into
[quoted text clipped - 7 lines]
> for a minimum of one year. Once your home loan has been in place for
> the required time, we'll be pleased to reconsider your application."

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.