Vance, It looks like its using a chr(13) and a chr(10). Which are a carriage return and a linefeed respectively.
Good luck. Matthew >From: "VDuke" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: <[EMAIL PROTECTED]> >Subject: Re: Line Break Character... in EXCEL FIELD >Date: Wed, 1 May 2002 15:38:01 -0500 > >Sorry, that is Alt-Enter. > >Shift-Enter is SQL. > >Vance > > >---------- Original Message ---------------------------------- >From: "VDuke" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >Date: Wed, 1 May 2002 15:03:21 -0500 > > >Does anyone know the chr() for a line break WITHIN an Excel field. > > > >I know in the program it is SHIFT-ENTER, but I am trying to generate an >excel file and I need to know what the CHR() is when generating it. > > > >Thanks, > >Vance Duke > > > > > > > >------------------------------------------------------------------------- > >This email server is running an evaluation copy of the MailShield anti- > >spam software. Please contact your email administrator if you have any > >questions about this message. MailShield product info: www.mailshield.com > > > >----------------------------------------------- > >To post, send email to [EMAIL PROTECTED] > >To subscribe / unsubscribe: http://www.dfwcfug.org > > > >------------------------------------------------------------------------- >This email server is running an evaluation copy of the MailShield anti- >spam software. Please contact your email administrator if you have any >questions about this message. MailShield product info: www.mailshield.com > >----------------------------------------------- >To post, send email to [EMAIL PROTECTED] >To subscribe / unsubscribe: http://www.dfwcfug.org _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
