Link to home
Start Free TrialLog in
Avatar of GCCTECHIE
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
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Access requires Chr(13) & chr(10) for a new line.

Obviously I don't know what your source data uses.
Avatar of GCCTECHIE
GCCTECHIE

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
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi mbizup,

thanks...that solution worked for me.
Glad that worked out :-)