Truncation of text field in delimited linked file

  • Thread starter Thread starter MPMarois
  • Start date Start date
M

MPMarois

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?
 
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?
 
Back
Top