Unbound Text Box On Form Limits Data Entry

  • Thread starter Thread starter Don Reid
  • Start date Start date
D

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
 
Don Reid said:
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?
Click to expand...

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.
 
-----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.
Click to expand...
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.
 
-----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
.
Click to expand...

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).
 
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.
 
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
 
Back
Top