• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 561
  • Last Modified:

change line in multiline textbox

Hi,

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 :
Jonathan
SimsDrive 2120 Beverly Hills California
1234567
jonathan@testing.com


Right now the syntax I'm using is :

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

Please help.

Thanks
0
ayufans
Asked:
ayufans
1 Solution
 
supunrCommented:
Text7.Text = ra.Fields(0) & vbcrlf & _
            ra.Fields(1) & vbcrlf & _
            ra.Fields(2) & vbcrlf & _
            ra.fields(3)  

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

Good LUck!
0
 
ayufansAuthor Commented:
ON THE SPOT !!! ^_^ tee hee

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

THANX
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now