Zero-Length String MSACCESS and ASP

[fpc]

I get the error &quot;Cannot be a zero-length string&quot; when someone removes data from an asp form or leaves a field blank. The Data comes from a MSACCESS Database, the fields are not required to have data. the error occurs when I try to write data back to the record for updating.. Can someone clue me in on how to eliminate this checking? My form field value looks like this : <%response.write rsemp(&quot;FirstName&quot%> Any help is appreciated..Fields in Access accept NULL..

 

[unicorn11]

Go to the access data base go the the table and choose to design it

select the field that you want to set to allow null
now at the bottom of the page the second last option is
allow zero length make that yes
that should solve your problem

but is is better method to validate the form

Regards Unicorn11
abhishek@tripmedia.com

[red]Luck is not chance, it's toil; fortune's expensive
smile is earned.[red]