Database dataset from updating
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.
Attachments provide a faster, easier, and more flexible way to view data from other programs.
See the Attachment entry, later in this table, for more information.
As you proceed, remember that updating data is not the same process as entering new data.If someone tries to enter text in that field, Access displays an error message and will not let that user save the changed record, a step that helps protect your figures.Show me how to view data types Access now provides two ways to view the data types for a table field.In turn, those design principles affect how you enter data.Remember these facts about database objects and design as you proceed.