In VBA: If Not IsNull (Me.SomeField) Then ' Do something Else ' Do something else End If The Else part may not be needed, depending on the situation. In the control source of a text box: =IIf([SomeField] Is Not Null,'Not Null','Null') In a query: NewField: IIf([SomeField] Is Not Null,'Not Null','Null') This will cause 'Not Null' or 'Null' to appear in the text box or query field. The Secret Tamil Book more. Substitute the actual actions you would have performed. In all cases use the actual field name. In the query you can name the field as you choose. Photo Editor Formal Attire. Fifa 14 Keygen For Pc on this page. You don't need to use NewField.
@GordThompson - sure, we're dealing with Access SQL, but that still doesn't impact my preference for Is Null over IsNull (that's why I put 'in a JET context'). Moreover, the Access SQL IIf is different from the Access VBA IIf, as I expect you know (the SQL one short circuits, the VBA one - rather annoyingly - doesn't). (MSSL 2008) SELECT IIF(Field1 IS NULL, 'NULL', 'NOT NULL') *** XX FROM MyTable [color. SQL Server Security Skills Microsoft Access Microsoft Access Products. May 21, 2014 I have the following SQL statement that I've been using against an Access Database (I've changed the # for date query): SELECT IIF(ISNULL(.)=TRUE,0.)- IIF.
