characters in cells

J

Jules

I am trying to type info into a cell and it will only let me type in about 25
characters. How can I get the cell to hold more characters? This is in a
form.
 
F

fredg

I am trying to type info into a cell and it will only let me type in about 25
characters. How can I get the cell to hold more characters? This is in a
form.
Click to expand...

1) Access Tables do not have cells, they have fields.
Access Forms do not have cells, they have controls.
Controls are different from fields, though controls may show the
values in the fields.

2) In Table Design view, set the Field Size to a higher value (up to
255).

3) Check the Table Field's Validation Rule property.
You may have a Validation Rule limiting data to 25 characters.

4) Check the Form Control's Validation Rule as well.

5) Check the Form Control's BeforeUpdate event, as well as the Form's
BeforeUpdate event.
Do you have any code there limiting the number of characters?
 
R

Rick B

A cell, is an Excel term. I believe you are using Access based on your
post. If you are talking about a control in an Access form, then you would
need to look at how that control is set up. Is there an input mask that
might be limiting it?

Is the control bound to a field in a table? If so, what type of field is
it? Does it have a size limit?

Do you get an error? If so, what does it say?

A few more specifics please.
 
Top