Comparison gives unexpected result

R

rsosabusiness

Access 2000 I have a continuous form to record transactions that are
batched together. When the form loads, I ask for the batch total with
an input box and store the input in a variant where I test it for
numerics and zero length input. If OK, I copy it into a box in the
form. As I enter the transactions, I sum them into another box. If the
user attempts to merge the batch with YTD transactions but the two
amounts do not match (txtBatchAmt <> txtTransTotal) , I issue a warning
and stay put. However, if the user inadvertenly tries to merge before
any transactions are recorded, txtTransTotal will be null, but the
comparison will behave as if the two amounts are equal. Although
nothing bad happens because of it, I do not understand how the
comparison gives such result.
Thanks for your help!
Robert
 
R

Rick Brandt

Access 2000 I have a continuous form to record transactions that are
batched together. When the form loads, I ask for the batch total with
an input box and store the input in a variant where I test it for
numerics and zero length input. If OK, I copy it into a box in the
form. As I enter the transactions, I sum them into another box. If the
user attempts to merge the batch with YTD transactions but the two
amounts do not match (txtBatchAmt <> txtTransTotal) , I issue a warning
and stay put. However, if the user inadvertenly tries to merge before
any transactions are recorded, txtTransTotal will be null, but the
comparison will behave as if the two amounts are equal. Although
nothing bad happens because of it, I do not understand how the
comparison gives such result.
Thanks for your help!
Robert
Click to expand...

Any comparison to a Null value is neither True nor False, but rather returns
Null. Wrap your txtTransTotal in the Nz() function to eliminate that.

If txtBatchAmt <> Nz(txtTransTotal,0)
 
R

rsosabusiness

Any comparison to a Null value is neither True nor False, but rather returns
Null. Wrap your txtTransTotal in the Nz() function to eliminate that.

If txtBatchAmt <> Nz(txtTransTotal,0)
Click to expand...
Thank you, Rick. Will try that.
Robert
 
Top