-
Hi,
I have a MS Access database with a couple of numeric fields (set as number,standard,2 decimals).
On my form I also have a couple of textboxes with the dataformat set to number & 2 decimal places. I want to insert these fields on my form into the table exactly as the user inputs them, but it keeps on rounding the numbers in the textbox and then writting it like that (rounded) to my table eg 5.56 becomes 6!!
Can anyone tell me how to rectify this!!??
-
If your data is unbound, force a conversion with the "CCUR" function; ie:
if len(trim(form.field)) < 1 then
database.field= 0.00
else
database.field = ccur(trim(form.field)
end if
