Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-16 : 09:35:22
|
| Milo T. writes "I'm having a problem writing to an excel file from a Access Database. I get some information from a <input type=textarea>.The problem is that if the user hits there "enter" button it inserts a invisible return character in the Database. When i go and write the Database to an excel file and i get to this field with the text area, the invisible character will move my records to the next line without me wanting it to move to the next line.I've tried replacing the code with addComm = Trim(Replace(getContent("additionalComments"), chr(13) ,""))and this seems to work when i output to the screen but when i write to the excel file there is still a hidden return character. I'm replacing the chr(13) with "" so eliminate it but nothing works.please helpthanks, milo" |
|
|
|
|
|
ASP Ascii Code chr(13) Problem