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:
- Trim: Removes both leading and trailing spaces in the data field.
- RTrim:Removes trailing spaces in the data field.
- LTrim: Removes leading spaces.
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.
Just click on the button for the Tiproom's Home Page.
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.
Date of last revision: 16 August 2001.