Trimming Data To Save Space

When you import data into Access, it is followed with leading zeros or spaces; in short, unwanted data takes up precious space. You can save database space by using the Trim functions as follow:


This feature is good for aligning data in the field to left or right. Try some experimentation with the Trim functions in order to get those data fields aligned such as addresses.

Tip comes from Susan Sales Harkins, a private consultant specializing in Access and VBA development. She currently has two technical books on the shelves: "Using Microsoft Access 97" and "Using Microsoft Access 2000." Both are QUE publications.
ag_button3   Just click on the button for the Tiproom's Home Page.
Date of last revision: 16 August 2001.