Like this article? We recommend
- To display the entire contents of a Memo field in an Access data table, remove the @ sign from the Format settings in the table properties window.
- When creating variably sized database fields in Access, reserve enough space so that future entries can fit.
- If a data field will never exceed a certain size, limit it to that size to save disk space.
- The larger and more complicated an Access database, the more likely it is to become corrupted, so keep it as small and simple as possible.
- You do not need an Access report to display Access data—you can use more-familiar tools such as Word and Excel, instead.