Greetings. I've got some Perl code that's inserting data into a MySQL, which is later being read & displayed by MS Access. I'm constructing a note, and I'm using: \n for new lines - to break up paragraphs. However, in Access, these \n characters appear as little boxes instead of new lines. What should I use to get Access to display a new line? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [email protected] website: http://www.nusconsulting.com.au
![]() |
0 |
![]() |
I think you can use \r instead of \n for Access and Excel. -----Original Message----- From: Daniel Kasak [mailto:[email protected]]=20 Sent: Wednesday, October 26, 2005 4:18 PM To: [email protected] Subject: New Line Character(s) Greetings. I've got some Perl code that's inserting data into a MySQL, which is=20 later being read & displayed by MS Access. I'm constructing a note, and=20 I'm using: \n for new lines - to break up paragraphs. However, in Access, these \n=20 characters appear as little boxes instead of new lines. What should I=20 use to get Access to display a new line?
![]() |
0 |
![]() |
--0-311467525-1130380957=:3534 Content-Type: TEXT/PLAIN; charset=ISO-8859-1 Content-Transfer-Encoding: QUOTED-PRINTABLE On Wed, 26 Oct 2005, Timothy Johnson wrote: > I think you can use \r instead of \n for Access and Excel. Are you sure about that?=20 I thought Windows used \r\n as a pair (or \n\r?) for the line delimiter. But then, I don't do Windows anymore, so I could be wrong :-) --=20 Chris Devers }#U=D9=AF=BC~=BAQ=FF=8D=8C --0-311467525-1130380957=:3534--
![]() |
0 |
![]() |