Office File Recovery

Why One Should Avoid Using Memo Fields for Grouping in Access

In this article we would learn the key aspects related to memo fields and learn why they are not really helpful and often result in bugs and truncation. A memo field can store large amount of information, allowing up to 65,536 characters, with various options. In the latest editions of MS Access, it can store up to 1 GB of characters and allows rich text formatting. But it is often suggested to avoid the use of Memo fields for purpose like grouping in MS Access. The article will discuss the...

Read more »

How to Use IsVisible and HideDuplicate Properties to Hide Duplicate Fields in MS Access

IsVisible and HideDuplicate property allow the user to hide the duplicate and repetitive fields in Microsoft Access but there is a small difference between the two. The article sums up the functioning of these two properties. MS Access is one of the reliable solution for managing databases in small and midsized firms. A common problem faced by users of Access databases is the unnecessary repetition of records in text fields. It can however be dealt with IsVisible property. The Duplicate...

Read more »

How to Number Records in Your Access Forms and Reports to Make Them More Organized

Numbering is one of the easiest ways of organizing data and in this article we apply the concept to on Access Forms and Reports Numbering or ranking data plays an important role in keeping records sorted and organized. And people often prefer arranging their Access reports and forms with numbering entries to gain an easy access to a particular subject. Numbering entries also come in handy if the user is looking for a particular range data. These steps can be used by casual as well as...

Read more »