How to I say Is Not Null in VBA

ms-access null vba
giles picture giles · Oct 3, 2011 · Viewed 207.3k times · Source

Hi I have the following expression. I'm trying to say "if the second field Is Not Null". Can you help.

Thanks

=Iif((Fields!approved.Value = "N" & Fields!W_O_Count.Value IsNotNull), "Red", "Transparent")

Answer

stuartd picture stuartd · Oct 3, 2011

Use Not IsNull(Fields!W_O_Count.Value)

Related questions

How can you check for null in a VBA DAO record set?

I have an optional field in a database that I'm pulling out using a DAO Record Set. I need to check whether or not the field is set before I concatenate it with other fields. So far I have the …

Read More
where to place CASE WHEN column IS NULL in this query

I'm having some trouble translating an MS Access query to SQL: SELECT id, col1, col2, col3 FROM table1 LEFT OUTER JOIN table2 ON table1.id = table2.id LEFT OUTER JOIN table3 ON table1.id = table3.id so far so good, …

Read More
How to do INSERT into a table records extracted from another table

I'm trying to write a query that extracts and transforms data from a table and then insert those data into another table. Yes, this is a data warehousing query and I'm doing it in MS Access. So basically I want …

Read More