GCCTECHIE
asked on
Displaying field that contains multi line
Hi,
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,
PRIMA SQUARE.
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.
Any ideas?
Thanks.
access-report.JPG
fromWebpage.JPG
exportedFromAccessTableToExcel.JPG
notepadplus.JPG
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,
PRIMA SQUARE.
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.
Any ideas?
Thanks.
access-report.JPG
fromWebpage.JPG
exportedFromAccessTableToExcel.JPG
notepadplus.JPG
ASKER
hi,
i'm not sure what it uses, since i can't see it.
i'm attaching the db, if it can be of any help.
AccessInterface.mdb
i'm not sure what it uses, since i can't see it.
i'm attaching the db, if it can be of any help.
AccessInterface.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi mbizup,
thanks...that solution worked for me.
thanks...that solution worked for me.
Glad that worked out :-)
Obviously I don't know what your source data uses.