Is there a maximum number of text for forms in access 2007?

  • Thread starter Thread starter Becky
  • Start date Start date
B

Becky

I am doing a call log in Access 2007 and employees will be using forms to
enter calls and time of calls. How can I change the maximum allowed of text
from 50 to 200 or more?
 
Open the table in design view, select the field in question and change
the Field Size property. A text field can be a maximum of 255. If you
need more than that, change it to a Memo data type.
 
I am doing a call log in Access 2007 and employees will be using forms to
enter calls and time of calls. How can I change the maximum allowed of text
from 50 to 200 or more?
Click to expand...

The Form is just a window, a tool to enter data in tables. The limit on
fieldsize is in the Table, not in the Form. A Text datatype can be set to any
size from 1 to 255 characters; a Memo datatype up to 64KBytes.
 

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

Similar Threads

maximum number of controls on a form 2
Bookmark code not working in Access 2007 1
Bookmark not working (again) in Access 2007 5
Maximum number of controls 7
maximum fields in reports access 2007 2
Forms only open maximized 3
Form for Parts-Tools Lists 0
Validate the number of checkboxes that can be true 0

Back
Top