G
Guest
In a table I have imported from a fixed width text file, one field is defined
(in the import specs) as a text field 2 characters wide. Various text
characters are imported correctly, like "NP" or "00". However, when it runs
across the two characters "0 " (that's zero with a space following) it trims
the field to just "0". Well, I need that space! Why is Access getting rid of
it? It's a text field, not a number field. (I have a field that sometimes has
a space before other characters and it leaves it alone.) The problem is,
later queries will look for the second character in that field which sometime
should be a space.
Any suggestions? Is there another field format that will treat the space as
a character to keep track of?
Thanks!
(in the import specs) as a text field 2 characters wide. Various text
characters are imported correctly, like "NP" or "00". However, when it runs
across the two characters "0 " (that's zero with a space following) it trims
the field to just "0". Well, I need that space! Why is Access getting rid of
it? It's a text field, not a number field. (I have a field that sometimes has
a space before other characters and it leaves it alone.) The problem is,
later queries will look for the second character in that field which sometime
should be a space.
Any suggestions? Is there another field format that will treat the space as
a character to keep track of?
Thanks!