Freakish null in checkbox issue

  • Thread starter Thread starter Jayyde
  • Start date Start date
J

Jayyde

I have a series of checkboxes that are coming in as null. When I try
to assign them to an integer variable I get a misuse of Null error, so
I put in an if/else to check for = Null. For some reason it's not
catching it, even though when I debug and check the immediate it says
it's = to null... So basically it looks like VBA knows that the
checkbox's value is null, but doesn't want to be nice and admit it so I
can handle it in code.
 
If you're saying that you've got a check like:

If Me.MyCheckBox = Null Then

the problem is that you cannot use the = sign to check for Null.

Use

If IsNull(Me.MyCheckBox) Then

instead.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
Greying Out Null Checkboxes 2
Null Value 3
Concatenate Checkbox 4
Checkbox TripleState "Null" looks same as "No" in Windows XP 6
Help with QBF CheckBox Query 2
Checkbox error 4
Access 2003 Checkbox Triple State 4

Back
Top