[AccessD] FYI: Adp Textbox Limitations

After spending several frustrating hours testing and searching
newsgroups, I have found a flaw in Access adp textboxes.

Here's how it looks from here: If you bind the textbox to a field that
is NOT a datatype of NTEXT, you can only put 255 characters in the
textbox. The weird thing is, if you have a textbox bound to a varchar
data type of size 300 and you put 300 characters in the textbox,
sometines Access DROPS the first 255 and only shows the last 45
characters!

If anyone knows any way around this, i.e., how to bind a textbox to a
varchar size 500 and actually put 500 characters in the database, please
share.

Myke