The default size for Access 2007 text fields has been increased from 50 to 255. If you rarely need fields that large, you can save yourself some time by changing the default to the size you use for the majority of the text fields you create. For example, suppose most of your text fields are around 50 characters. You can change the default to that size by following these steps:

  1. Open Access and click the Office button.
  2. Click the Access Options button.
  3. Click Object Designers in the pane on the left.
  4. Under Table Design, enter 50 in the Default Text Field Size box (Figure A) and click OK.

Figure A

The default text field size for all your databases will now be 50.

Miss an Access tip?

Check out the Microsoft Access archive and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.