Do I have to worry about Access storing Trailing or leading spaces

[Steve Stad]

Do I have to worry about Access storing Trailing or leading spaces or do I
need code such as......

Private Sub NAME_AfterUpdate()
Me.[NAME] = Trim(Me.[NAME])
End Sub

[Stuart McCall]

"Steve Stad" <Stev...@discussions.microsoft.com> wrote in message
news:0171C09C-961F-410F...@microsoft.com...

Trailing spaces are stripped out by Access, but leading spaces aren't. So
you can use LTrim instead of Trim (slightly faster, if only noticeable in
long loops).

[Steve Stad]

Thanks Stuart - but are you aware of being able to copy/paste a word or
string with a trailing space from an external source (e.g., web page, etc)
into access?

"Stuart McCall" wrote:

> .
>

[Stuart McCall]

"Steve Stad" <Stev...@discussions.microsoft.com> wrote in message

news:2B398B0D-92DF-4061...@microsoft.com...

I wasn't aware of that feature. I take it you've discovered this to be the
case. In that case yes, Trim is the correct function to use.

[Dirk Goldgar]

"Steve Stad" <Stev...@discussions.microsoft.com> wrote in message

news:2B398B0D-92DF-4061...@microsoft.com...

> Thanks Stuart - but are you aware of being able to copy/paste a word or
> string with a trailing space from an external source (e.g., web page, etc)
> into access?

I think that if you copy and paste into a text box or a cell of a datasheet,
trailing spaces will be removed. However, that is true for the character
that Access recognizes as a space, Chr(32), and would not be true for some
other characters that may appear to be spaces; for example, Chr(160).
However, Trim() won't remove such characters, either.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

[Steve Stad]

Thanks Dirk,
I must have encountered a Chr(160) space in the past. I eliminated these
with a validation rule in the tbl design - and never knew the difference
between chr(160) and chr(32).