How to Add an Unlimited Text Box in Microsoft Access

Written by emily ediger
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Add an Unlimited Text Box in Microsoft Access
You can increase your field size by using a "Memo" field. (Pixland/Pixland/Getty Images)

You can use a variety of data types in Microsoft Access to balance storage space requirements with database usability. For small amounts of information such as names or brief notes, a "Text" data type is often sufficient. But if you want to keep track of longer notes or larger amounts of alphanumeric information, you can add a text box that allows more data. Other text-based fields provide larger amounts of storage space for lengthy notes.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Open your table in "Design View" by right-clicking the title in the "Navigation Pane" and selecting "Design View." Whether you access the table from a query or form, you have to set the data type in the underlying table. If you are unsure which table to access, reference the "Object Dependencies" from the "Database Tools" tab of the ribbon.

  2. 2

    Create a new field by typing in a word or phrase into a new cell in the "Field Name" column. The default data type for new fields is "Text" which allows you to store alphanumeric characters in the field. "Text" data types are limited to 255 characters, which may not be long enough for lengthy notes.

  3. 3

    Select "Memo" from the "Data Type" drop-down box. Switching the "Data Type" from "Text" to "Memo" increases your field size to 65,536 characters. All field types in Access have a certain limit, and "Memo" fields provide the most amount of space for text.

Tips and warnings

  • If you have an existing field that you want to increase in field size, switch the "Data Type" to "Memo" without losing any data. Back up your database before changing any field properties in case an error occurs.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.