cannot be a zero-length string

[MadTom]

I get this error if I enter text into a Note textbox on a form and then go and delete all the text. (Field 'tblParts.P_Notes' cannot be a zero-length string.) Err 3315
I know the difference from Null and Blank or no text and have read many posts on this subject.
I have this code for the text box, and if I remove this Trim code I don't get the error. code to remove blank spaces.
I use this code in other text boxes and I don't get the error?

Private Sub txtNotes_AfterUpdate()
On Error Resume Next
   Me.[txtNotes] = Trim(Me.[txtNotes])
End Sub

Is there a work around or should I change ZLS setting? Just what to know why and what should be done.
Thanks for all the help!


Tom

[Bob Fitz]

Sounds like you just need to change the Allow Zero Length Setting to Yes.

[MadTom]

That does fix the problem and let's me use the Trim code.
I don't know why other text boxes don't give me an error?
Thanks for your help.
Tom

[orange]

Perhaps the other text boxes have real data -- not just a space that you TRIM away.
OR
Perhaps other text boxes have AllowZeroLength Yes.

[Micron]

I suspect that somewhere somehow you've already put zls in the data (before or after the value) before you get to this point. To test that, I would probably set the property to allow zls, do the trims and then create a query that searches these problem fields with "" as criteria (any records returned will be those where the field contains zls). If I knew how to search for zls and data in the same field I would have suggested that instead. What I don't get is why you're doing that in the code you show, unless you don't want leading spaces, which I suppose Access will allow. However, IIRC it won't allow trailing spaces anyway, so there ought to be no need to trim those if that's the intent.

[MadTom]

I can't seem to get the error in other fields, I did a query test as Micron suggested. The only thing that is different is the Notes field is set to Long Text.
I like using TRIM to remove leading spaces, some times spaces are added when using cut & paste.
I thank you all for your comments!
Tom

I will work with the ZLS set to yes if I get an error after a delete.