Solved

Displaying field that contains multi line

Posted on 2011-09-13
5
311 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:GCCTECHIE
  • 2
  • 2
5 Comments
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
Access requires Chr(13) & chr(10) for a new line.

Obviously I don't know what your source data uses.
0
 

Author Comment

by:GCCTECHIE
Comment Utility
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
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
Comment Utility
Excel uses CHR(10) for newlines....

Make a backup of your data and try this update query to replace Chr(10) with Chr(13) & Chr(10):

UPDATE CUSTOMER
SET Address =  Replace([Address],Chr(10),Chr(13) & Chr(10))

Open in new window


This worked for me in your sample.
0
 

Author Closing Comment

by:GCCTECHIE
Comment Utility
Hi mbizup,

thanks...that solution worked for me.
0
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
Glad that worked out :-)
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This is an explanation of a simple data model to help parse a JSON feed
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now