If I recall correctly, Access truncates trailing spaces when it writes to
disk, so you can't count on them being there when you next read the record.
I'd think it "unusual" if any application logic ware dependent on trailing
spaces.
Trailing spaces are truncated when entered via the keyboard (or through a
form). On the other hand if you use a query to put them in they will remain
until the field is edited.
If this is for export purposes, then I would use a query and a calculated field.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.