From: MPMarois on
Why does Access 2007 feel it's necessary to turn the string " 03" to "03"?
In previous versions of Access if there was a leading space in a text string
Access respected it and left it in the string. What's up with 2007?
From: GP George on
In a quick test in a query in my test database, Access 2007 does respect the
leading space in a text string, so we might need to dig deeper into your
particular situation to get to an answer.

Where and when are you seeing this behavior?



"MPMarois" <MPMarois(a)discussions.microsoft.com> wrote in message
news:29D4A49C-E052-42F6-A47D-5290519102C9(a)microsoft.com...
> Why does Access 2007 feel it's necessary to turn the string " 03" to "03"?
> In previous versions of Access if there was a leading space in a text
> string
> Access respected it and left it in the string. What's up with 2007?