Unable to enter more than 125 characters in text field.

[wilhelmmt]

I have a text box on a form where the user can enter a description of their
issue (along with other information) and the information is stored in a
temporary table which is used to generate a preview report. If I type in more
than 125 characters (roughly one line), junk characters, which look like
carriage returns, are written to the table, and the reports shows "??" for
the description. I have changed the parameters to 250 for text and also have
tried a memo field instead of a text field. I've looked through the
discussion forums for a similar problem, but have found nothing that helps. I
am using Access 2000. Has anyone else encountered this problem?

 

[Jeanette Cunningham]

Hi wilhelmmt,
the first thought is that A2000 had quite a few service packs - check that
you have applied all of them.
There are issues with junk characters appearing when using a query, have you
checked this link, it is not exactly your problem, but may give you a clue
as to where to being looking.

http://allenbrowne.com/ser-63.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Giammarco Ferrari]

Hi wilhelmmt,

Unfortunately for you, this is an access 2000 bug, you can bypass it
using a little bit of vba code, I've written a little post about it on
my blog ( http://revengstuff.wordpress.com ) to answer to another guy
with the same problem.

I hope it will be useful for you too.

Bye