Zero length string

[phayzer]

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!

 

[jimmythegeek]

You need to set the field in question's "Allow Zero Length Strings" property to Yes

 

[phayzer]

Hi Jim,

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.