truncating trailing spaces

  • Thread starter Thread starter Joel Levy
  • Start date Start date
J

Joel Levy

TIA for your help:

Noticed that Access 2002 automatically truncates trailing
spaces in data upon entry. Is this an option and if so
where is the option set?

Thanks,

Joel
 
Joel

As far as I know, Access assumes extra spaces after text are not worth
saving, and truncates. I don't know of a setting to "preserve" trailing
spaces.

Why do you need to keep them?

Jeff Boyce
<Access MVP>
 
Noticed that Access 2002 automatically truncates trailing
spaces in data upon entry. Is this an option and if so
where is the option set?
Click to expand...

It's actually a function of the text box, not the database. This works
exactly as expected:

update temp
set OName = "Eric "
where indexid=1

and leaves the trailing spaces, although they get evaporated as soon as you
use a text box or a datasheet to edit the field.

Not sure if that helps or not, but it may suggest a workaround if you
really need untrimmed text values.

Best wishes


Tim F
 
Back
Top