Access Memo field problem

[proline]

Hi All:
I am trying to insert two paragraphs of data into access in my vb app.

but only the first paragraph is going to the database. the second paragraph is missing.

is there a way to insert multiline, multi paragraph data into access..??

please help.

[RobDog888]

As long as your field is using the field data type of Memo and your not overrunning the default length for memo.
How many chars is the total and can you post your code to insert these values?

[proline]

while testing i tried the following text:
========================================================

Face-to-Face Programs Number of persons who indicated they would seek screening.

Face-to-Face Programs Number of persons who indicated they would seek screening1.

==========================================================

only the first one is showing in the database.

I am using the vb code (with insert statement) just like any normal string. I did not set any limits on memo field in access.

[RobDog888]

It must be something with the way your adding it to the field.

Memo Field Data Type:
Up to 65,535 characters. (If the Memo field is manipulated through DAO and
only text and numbers [not binary data] will be stored in it, then the size of
the Memo field is limited by the size of the database.)

Can you post your code?

[proline]

it is working.

after seeing your suggestion, that the way i am adding data..figured out the error.

i had some string replacement, cleaning going on elsewhere in the code. that was the error.

thanks for your suggestion.

[RobDog888]

No prob. That is usually the issue - concatinating the two.

:thumb;