Avatar of Murray Brown
Murray Brown
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Access VBA Null Date


I am gathering a date from an Access textbox that is formatted as such.How would I use Nz to make provision for an empty textbox ? I want to change null values to "Null" that can be used in a SQL statement

Dim oLicenceExpiryDate As String: oLicenceExpiryDate = Format(Me.LicenceExpiryDate, oDateFormat)
Microsoft AccessVBA

Avatar of undefined
Last Comment
Murray Brown

8/22/2022 - Mon