Text box max characters

[Dan]

I have a text box(txtDescr) on a form and when I try to
use it in an INSERT statement to a table, I get
an "Invalid Argument" error msg. I only get this error
msg if the length of txtDescr is greater than 127
characters. Is there a default max size on a text box on
a form ?

Thanks in advance
Dan

 

[Van T. Dinh]

AFAIK, a TextBox can display up to 64K characters.

The problem is likely to be in your INSERT statement.

Post details of your platform (Win version / Access version & Sevice Patch
version), the details of your source & destination Tables, the Form involved
and the INSERT SQL String. Someone may be able to identify the problem for
you.