You can use the commands on the Datasheet tab, or you can open the table in Design view.
The following sets of steps explain how to use both techniques.
A text field accepts a smaller number of characters than does a Memo field — from 0 to 255 characters.
In some cases, you can use conversion functions to perform calculations on the data in a Text field.
Also, if the database designer sets the field to support rich text formatting, you can apply the types of formatting that you normally find in word processing programs, such as Office Word 2007.
Using bind variables also improves query performance in the database, eliminates the need for special handling of literal quotation marks in the input, and protects against SQL injection attacks.
The following code shows a typical contains a client copy of the database data.
For more information about using rich-text formatting in a Memo field, see the article Format data in rows and columns.
Like Text fields, you can also run conversion functions against the data in a Memo field.