- By Gopal Sreeraman
- Feb 3, 2006
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.