I am using adobe acrobat 5.0 full version. I am sending the forms field 

values to a asp script. The problem is, when a value exists on the form, 

and when it is changed to a empty string value "", the empty string value 

is passed to the asp. The asp in turn tries to update the database with 

the empty string.



How do I set the value to the RecSet("EmptyField").value = "" with out 

getting a Error that says I can't set it to NoValue? I have the database 

setup so it will accept zero length values, and they are not required.



Is there any way to set it to ""?



Thanks for your helpfulness in advance.



NK

Something like this in your ASP might help by saving a space instead of an

empty string:



IF len(YourFormField) = 0 THEN

    ' A single space

    YourValue = " "

ELSE

    ' From Acrobat

    YourValue = YourFormField

END IF



RecSet("EmptyField").Value = YourValue



-- Jon Z.





----- Original Message -----

From: Nicholas Kowalewicz <nkowalewicz@n...>

To: Access ASP <access_asp@p...>

Sent: Friday, August 03, 2001 12:00 AM

Subject: [access_asp] Sending a Empty Value to the Database Record - Field





> I am using adobe acrobat 5.0 full version. I am sending the forms field

> values to a asp script. The problem is, when a value exists on the form,

> and when it is changed to a empty string value "", the empty string value

> is passed to the asp. The asp in turn tries to update the database with

> the empty string.

>

> How do I set the value to the RecSet("EmptyField").value = "" with out

> getting a Error that says I can't set it to NoValue? I have the database

> setup so it will accept zero length values, and they are not required.

>

> Is there any way to set it to ""?

>

> Thanks for your helpfulness in advance.

>

> NK