Microsoft Office Tutorials and References
In Depth Information
Access Data Types
A memo field tops out at 65,536 characters. To put it in perspective, that’s about the
same size as this chapter. If you need more space, then add more than one memo field.
Note: Technically, the 65,536-character limit is a limitation in the Access user interface, not in the
database. If you program an application that uses your database, it could store far more—up to a gigabyte’s
worth of information in a memo field.
If you need to edit a large amount of text while you’re working on the datasheet,
use the Zoom box (Figure 26-10). Just move to the field you want to edit, and then
press Shift+F2.
The value that’s being edited
Figure 26-10:
If you have lengthy
text in a field, it’s hard
to see it all at once
without a lot of
scrolling. By opening a
Zoom box (Shift+F2),
you can see more
content and edit it
more easily. You’ll
need to click OK (to
accept your edits) or
Cancel (to abandon
them) to get back to
the datasheet.
Formatted text
Like a text field, the memo field stores unformatted text. However, you can also store
rich text in a memo field—text that has different fonts, colors, text alignment, and so
on. To do so, set the Text Format field property to Rich Text (rather than Plain Text).
To format part of your text, you simply need to select it and then choose a
formatting option from the ribbon’s Home Text Formatting section. However, most of the
time you won’t take this approach, because it’s difficult to edit large amounts of text
Search JabSto ::

Custom Search