Forms- undesirable outcome on output file when user presses enter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a form that contains a "text area" form field. I send the results
to a .txt file using the file format "text database using tab as separator".
When the user presses the "enter" button within that box, all data entered
after pressing the enter button is shifted down to the next line in the
output file. As a result when I import that file into Excel, it does not
treat that data as part of the same field. It thinks the data after the
enter button is a new record and puts it on the next line down.

Can anyone help me fix this so that all the data entered in that field stays
together on the same line?

kgawlowicz
 
That's a limitation of using a text area field as a csv
Best you can do is add some client side JavaScript to strip the returns before sending the data
Check http://javascript.internet.com/forms/
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I created a form that contains a "text area" form field. I send the results
| to a .txt file using the file format "text database using tab as separator".
| When the user presses the "enter" button within that box, all data entered
| after pressing the enter button is shifted down to the next line in the
| output file. As a result when I import that file into Excel, it does not
| treat that data as part of the same field. It thinks the data after the
| enter button is a new record and puts it on the next line down.
|
| Can anyone help me fix this so that all the data entered in that field stays
| together on the same line?
|
| kgawlowicz
 
Back
Top