Unwanted char appearing in query

  • Thread starter Thread starter Nick Mirro
  • Start date Start date
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
 
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 ("")
 
Back
Top