Textbox character limit

[Julie]

Hello

I have a form where the user enters new information and
when the command button is clicked inserts the data into a
table.

One of the textboxes on the form inserts into a memo field
in the table but the textbox will only allow 127
characters to be entered before it returns a runtime error
message 3001.

If I use SQL to insert into the database memo field then
this allows more than 127 characters to be entered at once.

I don't understand why the text box won't allow more
characters to be entered - Does anyone know a way around
this?

Thanks

Julie

 

[Guest]

Thanks for replying but the field I am inserting into is a
memo field not a text field so there shouldn't be a limit
on the text characters I can insert surely??

 

[fredg]

Thanks for replying but the field I am inserting into is a
memo field not a text field so there shouldn't be a limit
on the text characters I can insert surely??

Re: but the textbox will only allow 127 characters to be entered
before it returns a runtime error message 3001.

The other replier wanted you to make sure that the TEXT field's Field
Size property was set to 255 characters, not the memo field.

 

[Larry D]

Table fields allow 255 characters of text but the table needs to be set to
255. Go to the table that corresponds to the textbox field. In the table
design field adjust the max characters for the text field you need to
modify.

larry

 

[Adrian Jansen]

The table field cannot contain a format specification, and the query feeding
data from the table to the form cannot contain any grouping, sorting or
other handling which looks at the memo field data itself. There are notes
on the MS knowledge base about this.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control