Unwanted char appearing in query

N

Nick Mirro

When a particular query is run, a small box character is being added to the
end of each field for each row. These boxes end up showing up in the
listboxes that use this query. What's causing it and how can I eliminate or
hide the characters?

Nick
 
D

Douglas J. Steele

Where did the data come from? For instance, Excel uses a Line Feed (Chr(10))
to make text continue onto a new line, where as Access requires both a
Carriage Return and a Line Feed (Chr(13) & Chr(10), in that order). If
Access only gets a Chr(10), it'll display it as a box.

Once you find out what the character is, you could use the Replace function
to change it into a zero-length string ("")
 
Top