Optional Text Field Error

<i><b>Originally posted by : is (imransohail@earthling.net)</b></i><br />Hi!<br />I have a form field (Optional) which is set as currency field in Access 2000, If the user submits a value there is no problem but when the field is left empty it give the following error,<br /> <br /> <br />Provider error '80020005' <br /><br />Type mismatch. <br /><br />/rootweb/file.asp, line 18 <br /><br />what is wrong with the field. I did not even validated the field, and I WANT IT TO BE AN OPTIONAL FIELD,<br /><br />Please Help.<br /><br />Imran<br /><br />

<i><b>Originally posted by : tom (tlannoo@conxion.be)</b></i><br />Hi,<br /><br />Well that's very simple. You just indicate in Access that you allow null values.<br />What i also do is put a default value in there, so you don't hv probs.<br /><br />Greetings,<br /><br />tom<br /><br /><br />------------<br />is at 9/9/2000 10:08:18 AM<br /><br />Hi!<br />I have a form field (Optional) which is set as currency field in Access 2000, If the user submits a value there is no problem but when the field is left empty it give the following error,<br /> <br /> <br />Provider error '80020005' <br /><br />Type mismatch. <br /><br />/rootweb/file.asp, line 18 <br /><br />what is wrong with the field. I did not even validated the field, and I WANT IT TO BE AN OPTIONAL FIELD,<br /><br />Please Help.<br /><br />Imran<br /><br />