Thank you very much for your info Bruce; Could you please tell me the
steps I need to do to actually change the default setting for the number of
character in a field. I am having trouble doing this.
Make sure that:
1) You have permission to modify the table's design (if this is *your* database,
this won't be an issue)
2) You make a backup of the file you will be modifying
3) You open the MDB file containing the actual table, not a link to the table
4) The field you want to change is a "Text" field, and
5) The field you are going to modify is not involved in a relationship with a
field in another table. If it is, there are other considerations the will need
to be addressed.
Now, in the database window, select the table containing the field you need to
modify and then click on the "Design" button (or right-click on the table and
select "Design View" in the pop-up menu). After the table has opened in design
view, find the subject field in the design grid and click on it. At the bottom
of the design grid, under the "General" tab, you will find the property "Field
Size". Change this number to the maximum number of characters that you expect
will be needed (up to 255) and then save and close the table design grid.