Null Syntax Help

[burrina]

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

 

[namliam]

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)

 

[jdraw]

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.

 

[pbaldy]

Or this if you mean when there are no records:

http://access.mvps.org/access/forms/frm0022.htm

 

[burrina]

The criteria was no value in txtHrsRem

I did resolve the issue though.

Thanks,