Converting Memo to String(VB & Access)

[getmeidea]

I want to get the function which will convert the memo type value stored in Access to Continuous string in VB.
Eg: The field Address in EmployeeInfo table contains Address field with Memo datatype. And one value entered in VB is
David,
Bangalore,
Karnataka.

When i access this vaue using VB, i want to get a continuous string value like "David,Bangalor e,Karnataka."

What function i can use for this ?

[getmeidea]

I want to get the function which will convert the memo type value stored in Access to Continuous string in VB.
Eg: The field Address in EmployeeInfo table contains Address field with Memo datatype. And one value entered in VB is
David,
Bangalore,
Karnataka.

When i access this vaue using VB, i want to get a continuous string value like "David,Bangalor e,Karnataka."

What function i can use for this ?

Myself got the solution...I used the function
Replace(rs("Add ress").Value, vbNewLine, ""))

And now it is giving continuous string.

[vijaydiwakar]

I want to get the function which will convert the memo type value stored in Access to Continuous string in VB.
Eg: The field Address in EmployeeInfo table contains Address field with Memo datatype. And one value entered in VB is
David,
Bangalore,
Karnataka.

When i access this vaue using VB, i want to get a continuous string value like "David,Bangalor e,Karnataka."

What function i can use for this ?

try to use replace function with chr(13) to be replaced with space or whatevr u want