Unbound Text Box On Form Limits Data Entry

[Don Reid]

I have a form with an unbound text box control that I want
to write back to a memo field. The text box control though
limits my data entry to 255 characters. I need a control
where I can collect data for my memo field, up to 65000
characters.

Is there such a control, or is there a way I can remove
the limit on my text box control?

Thanks in advance

 

[Rick Brandt]

I have a form with an unbound text box control that I want
to write back to a memo field. The text box control though
limits my data entry to 255 characters. I need a control
where I can collect data for my memo field, up to 65000
characters.

Is there such a control, or is there a way I can remove
the limit on my text box control?

Are you sure it's unbound? TextBox controls do not have a 255 character
limit. Text *fields* in tables do, but not TextBoxes on forms/reports.

 

[Guest]

-----Original Message-----


Are you sure it's unbound? TextBox controls do not have a 255 character
limit. Text *fields* in tables do, but not TextBoxes on forms/reports.

Yes, absolutely it's unbound, but maybe it's the query? I
use the text box to user input; when the user is done,
they click a button that fires a query that updates a
table. Once I get beyond 255 characters, an "Invalid
Argument" message is returned and the data is not updated.

 

[Oliver Göhre]

-----Original Message-----
I have a form with an unbound text box control that I want
to write back to a memo field. The text box control though
limits my data entry to 255 characters. I need a control
where I can collect data for my memo field, up to 65000
characters.

Is there such a control, or is there a way I can remove
the limit on my text box control?

Thanks in advance
.

A long time ago i had a similar problem. I didn`t search
for very long; all i did, was to actually bind the form to
a field which only had temporary character. This is not a
beautiful solution, but it worked at the time (Access97).

 

[Don Reid]

I double checked to see where this is cutting off my data,
and it is at 128 characters, and it's definitely unbound.
I can add up to 127 characters, but as soon as I hit the
128th character, the "Invalid Argument" command is
returned.

I also ran the process in debug mode, and it is failing at
the query. I will post a similar thread in queries, as
that seems to be the problem, not the form.

My apologies, and thanks for the replies.

 

[Adrian Jansen]

Your problem is in the query. Any query which uses clauses like "Distinct"
or a sort or in any other way has to look at the actual data returned, will
only return 255 or so characters.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[TC]

Unbound textboxes *do not* have the 255 limit.

TC