Could somebody help me out.

I have, for example a six field database.

Some of the fields need to have entries, and others need not.

If the fields in a form are left blank, then the form throws up an http 500 error.

Any ideas how to make the textfields in a form accept a nul entry and not report errors. I am asking third party users to complete forms and they obviously would rather leave fields blank than having to fill in with 'xxx's' or '0's'.

Many thanks

There are two ways you can come at this:

1.) Force the user to put something in the fields, using some form validation like Yaromat's Check Form.

2.) Simply set your DB to except zero length strings in the fields. This can be done in Access by opening up your table using 'Design View' and then making sure 'Required' is set to NO and 'Allow Zero Length' is set to YES. Then, there will be no more errors...

(DWMX|IIS5|WXP|ASP/VB)
*Connman21*
www.conncreativemedia.com