Also if it is a long form (all text boxes are sent at the end) there is a patch to allow longer forms at
http://support.microsoft.com/default.aspx?scid=kb;en-us;820915
--
| >-----Original Message-----
| >I have an online form setup that will send via email the
| >results. Several people have told me they have filled in
| >the text box with a paragraph but that data was not sent
| >to me.. it is showing blank. Every time I test it and
| >enter data it sends it to me. Also, one time it sent
| >half the data. People are getting frustrated with
| >resending the data. Does anyone know what is going on?
| >Ryan
|
| If the form field in question is a TextArea box, the
| visitors may be entering carriage returns. Then, if you
| view the data in Access, only the data up to the first
| carriage return will be visible.
|
| To get rid of the line endings, you may need to filter
| carriage returns and line feeds out of your Access query.
| For example, you might need to code the field as:
|
| replace(replace([myfield],vbcr," "),vblf," ") AS fixedfield
|
| Jim Buyens
| Microsoft FrontPage MVP
| (e-mail address removed)
|
http://www.interlacken.com
| Author of:
| *------------------------------------------------------*
| |\----------------------------------------------------/|
| || Microsoft Office FrontPage 2003 Inside Out ||
| || Microsoft FrontPage Version 2002 Inside Out ||
| || Web Database Development Step by Step .NET Edition ||
| || Troubleshooting Microsoft FrontPage 2002 ||
| || Faster Smarter Beginning Programming ||
| || (All from Microsoft Press) ||
| |/----------------------------------------------------\|
| *------------------------------------------------------*
|
