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.