change line in multiline textbox

Posted on 2003-03-06
Medium Priority
Last Modified: 2008-02-01

I have multiline textbox that I want to fill with data from an access recordset.

How do I fill those textbox so that each fields would have one line ?

for example :

first line would be name (field 0 of db table)
second line would be address (field 1 of db table)
third line would be phone number (field 2 of db table)
fourth line would be email address (field 3 of db table)

right now the appearance on the textbox would be something like this :

JonathanSimsDrive 2120 Beverly Hills California1234567jonathan@testing.com

note than the name is : Jonathan
the address is : SimsDrive 2120 Beverly Hills California
phone number is : 1234567
email address is : jonathan@testing.com

What must I wrote on the coding so that the textbox would looks like :
SimsDrive 2120 Beverly Hills California

Right now the syntax I'm using is :

Text7.Text = ra.Fields(0) & _
             ra.Fields(1) & _
             ra.Fields(2) & _

Please help.

Question by:ayufans
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 11

Accepted Solution

supunr earned 80 total points
ID: 8085502
Text7.Text = ra.Fields(0) & vbcrlf & _
            ra.Fields(1) & vbcrlf & _
            ra.Fields(2) & vbcrlf & _

vbcrlf = new line
equivalent to '\n' in C

Good LUck!

Author Comment

ID: 8085614
ON THE SPOT !!! ^_^ tee hee

Thanks very much supunr. Just plain GREAT ! ^_^


Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question