Hi, I have form that the entries will be written into text file, next it will be imported into Access database. My problem is in Text Area Input Form (scrolling text box). Sometime user press "enter" while he fills the text area. And this will be written as new line(s) in the text file . My question is: How to join this line(s) back into 1 line (that it supposed to be). I have tried with this:
Function FormatRevStr(String) on Error resume next String = Replace(String, "" & vbCr & "", " ") FormatRevStr = String End Function It will be put lines into 1 line in text file, but when it imported into access database, it still read multiple lines as before. Anyone can help me, thank You very much... Christ ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
