truncating trailing spaces

[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

 

[Jeff Boyce]

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>

 

[Tim Ferguson]

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

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