Textbox Problem?

[rukk]

Hi,
How many charecters can be kept in a Textbox. Its allowing me only 9 charecters, but i need to enter 12.
How to fix it.
I am using this textbox on access forms.

 

[RoyVidar]

Don't know how many, but lots more.

The 9 charachter limit is most likely because of the field size of the field it's bound to, or other constraints put on either the control or field.

Roy-Vidar

 

[rukk]

Is there any way to change that field size to 12.
Or if you could suggest me which other control will work good for this, that will be great.

 

[RoyVidar]

Open the table, find the field where the size isn't appropriate, change the size to something more fitting. Save the table.

Form controls doesn't always inherit changes in properties. If thats the situation, delete the old control, and add it again, from the Field list/add a new control and set the controlsource to the original field.

Roy-Vidar

 

[rukk]

But in table the field size is Long integer, still its taking only upto 9 char.

 

[RoyVidar]

Long Integer fields take numbers/digits, not chars. Long integers, according to the help files (I just pressed F1 in the field size part for a field) can take numbers up to:

2 147 483 648

The "length limit" for long integer is 10 digits, providing the value is below the limit from the help files that I referred above. You wanted 12.

Simply choose another field size/datatype. If you are going to perform math on the field values, consider another numeric (Decimal?), if not, use text datatype with size 12.

Roy-Vidar

 

[rukk]

yep, i took text, Thanks a lot.