Solved

Access 2010 - If stmt not executing on true value of NULL

Posted on 2011-09-18
2
314 Views
Last Modified: 2012-05-12
I have the following IF stmt:

if recordset1!samplevalue = null then
  msgbox "true"
else
  msgbox "false"
end if

The value of recordset1!samplevalue is NULL but the message "true" is skipped over and "false" is printed instead.  I've also tried using "if recordset1!samplevalue is null" but wrong answer pops up.
0
Comment
Question by:SFWolverine
2 Comments
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 125 total points
ID: 36558310
try this

If isnull(recordset1!samplevalue) then

msgbox "true"

else
  msgbox "false"
end if
0
 

Author Closing Comment

by:SFWolverine
ID: 36558406
Thank you!
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question