why are carriage returns showing as boxes?

  • Thread starter Thread starter kmiles17
  • Start date Start date
K

kmiles17

When I copy and paste XML into access, the carriage returns are displaying as
boxes instead of space in my reports. If I copy the XML out of access and
paste it into wordpad it shows as spaces instead of the boxes.
 
kmiles17 said:
When I copy and paste XML into access, the carriage
returns are displaying as boxes instead of space in my
reports. If I copy the XML out of access and
paste it into wordpad it shows as spaces instead
of the boxes.

"Because that's the way they are represented in the font being used" would
seem to be a likely explanation. A "new line" in Access is represented by
the control characters Carriage Return and Line Feed, though in some cases,
like MsgBox, only one is required.

Larry Linson
Microsoft Office Acess MVP
 
The carriage return in excel and some xml files are different then what is
used in Access and thus creates the small vertical bars or small box. See
http://support.microsoft.com/kb/q115576/ for one solution. This frequently
shows up when importing an excel file with hard returns in one cell.

If you search Google for small box excel import you'll find many other cures
which although they don't say it, includes xml translations.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top