To access a field's AllowZeroLength property by using Visual Basic, use the DAO AllowZeroLength property or the ADO Column.Properties("Set OLEDB:Allow Zero Length") property.


I really don't understand this "Note" I found in the Access help. Do I have to use this line of code even though I set my fields to allow zero length?

Is there any problem with telling my script if a text box is empty make the value " "? Will that cause problems?

No, that line refers to programmatic access to your database.

Here's how it works. Like I said, there are subtle differences in the way these properties are behaving. Null and a zero length string are not really the same:

Required No
Allow Zero Length Yes

Both will work: Required Yes
Allow Zero Length Yes

This will work: but this won't: Required Yes
Allow Zero Length No

Now both lines will fail, because the field is required and cannot be an zero length string

Required No
Allow Zero Length No

This is the opposite of No / No. That is, this will work: but this won't: Because the field is not required, you can insert null. However, you can't insert a zero length string as the field does not permit that.

Null is not considered the same as an empty string. An empty string is a string with zero length, while null is undefined.

Confusing, don't you think?

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

I see, I can send the (MyColumn) Values(null) instead of (MyColumn) Values('')
This is great news...I didn't really understand until you laid it out for me.

Thanks Imar
    xoxoxo

You're welcome.

I don't use Access very much, so I wasn't 100% sure about all the settings and their behavior. Writing it down helped me as well. That's why I always suggest people to be supportive in forums too; it will also improve your own knowledge ;)

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hi Freind,
to make the update code working proberly write below :

If Len(Trim(Reques.Form("attn"))) <> 0 Then

Connect.Execute = "UPDATE vendor Set" & _
 & " uiid = '" & CStr(Request.Form("uiid")) & "'," & _
 & " company = '" & CStr(Request.Form("company"))& "'," & _
 & " attn = '" & CStr(Request.Form("attn")) & "'" & _
 & " WHERE key ='" & Request("server_index") & "'"

End If

ali

Hi Ali,

I guess this won't work, I am afraid.

With your code, the entire UPDATE will not take place when Request.Form("attn") does not have a value.

However, it is perfectly possible that uiid and company must be updated, even when attn is empty.....

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.