What is Null in Microsoft Access? How to use Is Null, Is Not Null, IsNull, and Not IsNull

[@rabidfollower]

I never use IsNull() because a seemingly empty value could be a zero-length string or even a string of spaces. So I prefer to use Len(Trim(Field1 & "")) = 0 to take all such possibilities into account. And that has become my habit since the beginning. I know Access makes things easy and automatically turns an empty textboxes into null. But if you ever import data from other people's databases, you just can't assume all their empty fields are null. Your code will need to check for everything: nulls, zero-length strings, spaces, etc.

[@599CD]

Interesting. Thanks for sharing. :)

[@tomthumb3085]

Very handy tip thanks Richard. I have a question that you may be able to answer, which has been troubling me: how do I assign a “click” to a button press in my database please.

[@599CD]

Watch this: 599cd.com/VBA

[@moodkn]

Great Sir !

[@599CD]

Thanks

[@alfredbanda6385]

great sir i like it

[@599CD]

Thanks for liking

[@alfredbanda6385]

am thank you Mr Richard

[@599CD]

Welcome

[@manoj9351]

Sir can u plz help me in my project of ms access invoicing software when I enter the product in subform all other fields like mrp rate tax percentage is auto populated I create calculated fields ofr this. And use dlookup but all these things are working in accessform not update in table

[@599CD]

599cd.com/ASK

[@nabeeljakway8793]

Thanks

[@599CD]

Welcome

[@balaboopathy1228]

Not able to find the join button . Please help

[@599CD]

It might not be available in your country. You can join on my web site at 599cd.com/THM

[@SkepticleOrc]

Is making my database an ACCDE file the only way to prevent people from accessing the [background] ? I recently made a database, had log ins, user permissions, the whole shazam. chKey was deactivated. I turned all the menus off and I was convinced it was no longer accessible. But after a little research, all I had to do was rename the file, press and hold the shift key whilst the database opened, click the X on the macro warning. After that, you can access the privacy options, set the load form to nothing, reload it and bam. Everything showed up.

[@599CD]

A properly designed ACCDE file will not let you access form design. Period.

[@t.wadegonder1288]

@@599CD Got a training video on that?