Null Syntax Help

burrina

Registered User.
Local time
Today, 05:09
Joined
May 10, 2014
Messages
972
I need to check if it has no value and eliminate my error saying it has no value.

If [Forms]![frmTimeCards]![frmConfirmation].[Form]![txtHrsRem] = 0
 
isnull(yourfield)

That what you are looking for?

Alternatively you can use the NZ function (or is it NVL?? Too much oracle on the brain sorry)
 
Further to namliam's post, what exactly do you mean by no value?
You sample indicates you are checking for 0 --- which could be a valid or default value.

IsNull or NZ could check for NULL (unknown value), but depends on what you mean.
 
The criteria was no value in txtHrsRem

I did resolve the issue though.

Thanks,
 

Users who are viewing this thread

Back
Top Bottom