hi i want to ask u guys..
coupon_bbtxt = Format(listbuyback.Column(5), "0.00000%") --> my textbox that get its' value from a listbox
Set buyadd_db = CurrentDb.OpenRecordset("buyback")
buyadd_db.AddNew
buyadd_db!coupon_bb = Me!coupon_bbtxt
buyadd_db.Update
the field "coupon_bb" has percent format with decimal places set to 5
but when i'm updating the table it show me the error message "Data type conversion error"
could anyone help me?
thx
coupon_bbtxt = Format(listbuyback.Column(5), "0.00000%") --> my textbox that get its' value from a listbox
Set buyadd_db = CurrentDb.OpenRecordset("buyback")
buyadd_db.AddNew
buyadd_db!coupon_bb = Me!coupon_bbtxt
buyadd_db.Update
the field "coupon_bb" has percent format with decimal places set to 5
but when i'm updating the table it show me the error message "Data type conversion error"
could anyone help me?
thx