I have a code based on whether we have a zip code on a customer or not. I have trapped for Null and "", which works perfect but only if the zip code has never been entered. Here's where my problem comes in. If someone deletes a zip code out of the customers record and leaves the field blank, I just can't seem to trap (whatever value this has become). I have tried Nz, IsNull, Len, "" but just can't seem to find any combination that will trap it.
Could someone please take a little time and give me a hand with this?
Thanks ahead of time,
Shane
Could someone please take a little time and give me a hand with this?
Thanks ahead of time,
Shane