Character limit on unbound textbox

  • Thread starter Thread starter Tilman Bergt via AccessMonster.com
  • Start date 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.
 
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.
 
Back
Top