esiahc
Posts: 8
|
Posted: 09/09/2007, 2:50 AM |
|
Hello,
Couldn't the "Export to Excel" function of CodeCharge convert the \r\n characters found in SQL into something that can be interpreted by Excel as a proper end of line?
At the moment, if a user enters text with more than one line in a "textarea" field ("Enter" key), that is translated in SQL by the character "\r\n" but when the database is exported to Excel every new line in the textarea results as many new records in Excel!...
|
|
|
bedollandres
Posts: 48
|
Posted: 10/04/2007, 11:57 AM |
|
add this in the before show event of the label:
Form.Label.Value = Replace(Form.Label.Value, vbCRLF, " ")
_________________
bedollandres |
|
|
|