text box limit

#1

Hi,
sorry for my english
using Access 2003,
in a form there's a cmbbox that saves values in a text box. I've made
it using the wizard.
I. e. selecting first name in cmbbox it puts last name in text box.
The problem is that the second name can't be longer than 30 characters
because, if it is, Access display an error "Input or paiste less
data".
How can I modify this limit?
Thank you so much.

Remigio

#2

remigio wrote:

Quote:

Hi,
sorry for my english
using Access 2003,
in a form there's a cmbbox that saves values in a text box. I've made
it using the wizard.
I. e. selecting first name in cmbbox it puts last name in text box.
The problem is that the second name can't be longer than 30 characters
because, if it is, Access display an error "Input or paiste less
data".
How can I modify this limit?
Thank you so much.

Remigio

Sounds like your TextBox is bound to a table field and the field has the 30
character size limit. Go into the design view of the table and change the
length there.

An unbound TextBox can hold over 60,000 characters.

#3

On Sep 23, 1:17*pm, Rick Brandt <rickbran... (AT) hotmail (DOT) com> wrote:

Quote:

remigio wrote:
Hi,
sorry for my english
using Access 2003,
in a form there's a cmbbox that saves values in a text box. I've made
it using the wizard.
I. e. selecting first name in cmbbox it puts last name in text box.
The problem is that the second name can't be longer than 30 characters
because, if it is, Access display an error "Input or paiste less
data".
How can I modify this limit?
Thank you so much.

Remigio

Sounds like your TextBox is bound to a table field and the field has the 30
character size limit. *Go into the design view of the table and change the
length there.

An unbound TextBox can hold over 60,000 characters.

Thank yoiu very much!
Remigio

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

text box limit

comp.databases.ms-access comp.databases.ms-access

text box limit - 09-23-2010 , 04:53 AM

Re: text box limit - 09-23-2010 , 06:17 AM

Re: text box limit - 09-26-2010 , 10:42 AM