I have a simple web interface where administrators can add customer data. From the browser, admin will enter several info. The address field will sometimes have several lines, e.g.
No 3, BLOCK A,
I'm using the DevExpress Gridview to achieve this goal, and from the web page, the lines are recognized.
However, some of our backoffice users use a MS Access interface to generate invoices, etc. When the address was entered from the web page, the carriage returns don't seem to follow through.
I can't do a replace in MS Access because i'm not sure what to look for. I know the characters are hidden in the text somewhere, because exporting from the access table to excel shows the fields with multi lines.
I'm attaching some screenshots of the different views.