checking for blank values

[Guest]

I have been having problems checking for blank values on fields with
date/time and currency datatypes.

Example, I have tried the syntax statring with the following and they have
not worked out
If txtDate = ""
if txtDate is null
if txtAmount = ""
if txtAmount is null

Please help.

 

[Bruce Rusk]

I have been having problems checking for blank values on fields with
date/time and currency datatypes.

Example, I have tried the syntax statring with the following and they have
not worked out
If txtDate = ""
if txtDate is null
if txtAmount = ""
if txtAmount is null

Please help.

You can try (overkill but effective):

if LenB(Cstr(Nz(txtDate,vbNullString))) = 0

 

[Guest]

Thanks for your prompt response but can you further elaborate because I did
not quite get it.