Access Memo field problem

[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;