I have a form that has many fields on it to add information to a table.
However, some of the form fields are optional and may or may not contain
text. If the field IS left blank however, and the user submits the form, ASP
complains that the form field cannot be a blank entry. Is there a way around
this? I'm using an MS Access 2000 database.

Thanks in advance.

--Ashley

-----Original Message-----
From: Vandana Sahasrabudhe [mailto:panipuri99@h...]
Sent: Monday, August 05, 2002 11:13 AM
To: Access ASP
Subject: [access_asp] Re: adding data..page 595


OK :-), Thanks! 

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
 

Make sure that your table fields in Access are set that the field is not
required, and/or that it will allow zero length string, depending on your
field type.

Cathryn

----- Original Message -----
From: "Young, Ashley" <Ashley.Young@c...>
To: "Access ASP" <access_asp@p...>
Sent: Monday, August 05, 2002 11:33 AM
Subject: [access_asp] Addin Blank Form Fields to Database Table


> I have a form that has many fields on it to add information to a table.
> However, some of the form fields are optional and may or may not contain
> text. If the field IS left blank however, and the user submits the form,
ASP
> complains that the form field cannot be a blank entry. Is there a way
around
> this? I'm using an MS Access 2000 database.
>
> Thanks in advance.
>
> --Ashley
>
> -----Original Message-----
> From: Vandana Sahasrabudhe [mailto:panipuri99@h...]
> Sent: Monday, August 05, 2002 11:13 AM
> To: Access ASP
> Subject: [access_asp] Re: adding data..page 595
>
>
> OK :-), Thanks!
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
>
>
>