Character limit on unbound textbox

  • Thread starter Tilman Bergt via AccessMonster.com
  • Start date
T

Tilman Bergt via AccessMonster.com

Hi,
An unbound textbox always seems to keep the character limit of the field it
was previously bound to. I.e. if I programmatically set the ControlSource
of a textbox to "" and do the same for the RecordSource of the form, there
is still a limit on the characters the user can enter (and its not 255, but
whatever the limit was for the table field, 30 or 40 characters). Does
anybody know a way this behaviour can be turned off or how this limit can
be programmatically changed without binding the textbox to an appropriate
field beforehand? This is probably a strange question, but any help would
be greatly appreciated. Thanks.
 
A

Allen Browne

Open the form in design view, and remove the Control Source from the text
box or the RecordSource of the form. Save the form this way, so it is
unbound.

Now in the Open event of the form assign the ControlSource or RecordSource.
Because the form was opened unbound, when you later remove the ControlSource
it might not have the limitation. No promises, but give it a shot.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top