characters in cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.

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?
 
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.
 

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

Back
Top