edit variable length items in "Access" database tables

  • Thread starter Thread starter CHARLES_WALKER
  • Start date Start date
C

CHARLES_WALKER

In my database table I am holding a variable length item in a database
record; the item may be from two to six alphabetic characters long.
Trailiing spaces pad the item where required.

To print out the item in a report, the item itself is sandwiched between two
fixed-length items separated by an oblique stroke, (forward slash): -
***/variable length/***.

How can I suppress the trailing spaces in my variable length item when
printing results ?

Yours Sincerely,

CHARLES WALKER
 
Take a look at the RTrim function or even the Trim function.

RTrim(SomeField) will trim trailing spaces off a field
Trim([SomeField]) will trim leading and trailing spaces off a field

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top