Not is Null code not working

[Leesha]

Hi,
I have [frmStoreDemographicsUpdate] that opens from [frmStoreDemographicsLookup]. [frmStoreDemographicsLookupLog] also opens to store info for requerying [frmStoreDemographicsUpdate]. All of this works fine. If txtStoreStatusEndDate on [frmStoreDemographicsLookupLog] is null, cmdEnable should not be disabled. If there is a date in txtStoreStatusendDate, cmdEnable should be disabled. The code isn't working. I've uploaded a stripped down version of the database.

Thanks,
Leesha

[HansV]

The text box isn't null, it contains the empty string "". Try this line:

ElseIf Nz(Forms!sfrmStoreDemographicsLookupLog!txtStatusEndDate) <> "" Then

[Leesha]

That worked perfectly! I didn't realize you could use Nz for anything but numbers. Does it work with text as well?

Thanks!
Leesha

[HansV]

Yes, you can use Nz with text fields/controls too. There are two forms:

Nz(expression) returns expression unless that is Null, then it returns an empty string "". It is equivalent to Nz(expression, "").

Nz(expression, "alternative") returns expression unless that is Null, then it returns "alternative".

[Leesha]

Thanks for the info. Ahhhhh, the possiblities!
Leesha