Zero length string

phayzer · Aug 27, 2000

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 · Aug 28, 2000

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

phayzer · Aug 28, 2000

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.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Zero length string

phayzer

Technical User

jimmythegeek

Programmer

phayzer

Technical User

Similar threads

Part and Inventory Search

Sponsor