Re: clear integer values in text boxes
Hi all,
I have a problem clearing or displaying empty values in text boxes.
These fields are binding to a table and are storing integer data type. I want to clear the values in these text boxes when user clicks on a button but the fields that stores the number gives me this error message:
Run time error 2757
There was a problem accessing a property or method of the OLE object.
here is my code:
Private Sub msp_barcode_Click()
Me!msp_barcode.Value = ""
Me!material_lotnum.Value = ""
Me!insert_lotnum.Value = ""
Me!mfg_dt.Value = ""
doesn't work
Me!bag_num.Value = ""
Me!bag_quantity.Value = ""
works
Me!bag_num.Value = 0
Me!bag_quantity.Value = 0
It makes sense not be able to store empty string in integer field but I can't figure how?
I appreciate your input.
Hi all,
I have a problem clearing or displaying empty values in text boxes.
These fields are binding to a table and are storing integer data type. I want to clear the values in these text boxes when user clicks on a button but the fields that stores the number gives me this error message:
Run time error 2757
There was a problem accessing a property or method of the OLE object.
here is my code:
Private Sub msp_barcode_Click()
Me!msp_barcode.Value = ""
Me!material_lotnum.Value = ""
Me!insert_lotnum.Value = ""
Me!mfg_dt.Value = ""
doesn't work
Me!bag_num.Value = ""
Me!bag_quantity.Value = ""
works
Me!bag_num.Value = 0
Me!bag_quantity.Value = 0
It makes sense not be able to store empty string in integer field but I can't figure how?
I appreciate your input.