Zero length string
Zero length string
(OP)
Hello,
I've created a form that people will fill out online. When the form is filled out, the information is inserted in an Access database.
When I test the form (using PWS), I fill in all questions in the form. However, I'm getting this error message:
[Microsoft][ODBC Microsoft Access Driver] Field 'client_information.genre' cannot be a zero length string. In design view, "Allow zero length" and "Required" are both set at "No". I've tried setting it at "Text" and "Memo".
Any suggestions as to what the problem is?
Thanks!
I've created a form that people will fill out online. When the form is filled out, the information is inserted in an Access database.
When I test the form (using PWS), I fill in all questions in the form. However, I'm getting this error message:
[Microsoft][ODBC Microsoft Access Driver] Field 'client_information.genre' cannot be a zero length string. In design view, "Allow zero length" and "Required" are both set at "No". I've tried setting it at "Text" and "Memo".
Any suggestions as to what the problem is?
Thanks!
RE: Zero length string
Jim Lunde
compugeeks@hotmail.com
CompuGEEKS
Custom Application Development
RE: Zero length string
Thanks for your message. I said "yes" to Allow Zero Length Strings but only certain information from the form is inserted into the database. Also, I don't really want to allow zero length strings - in other words, I want the user to fill out that part of the form. I have also set Required to yes as well, in some cases.
However, for some reason select data isn't being inserted into the databse.