Variable doesn't store decimal value correctly (1 Viewer)

Hi guys

I am getting a problem in storing correct decimal value in a textbox. E.g text12=7.30 and text83=6.10 then in the following code text130 stores value 1.2 which is not correct. The right value should be 1.20


Can anyone please sort out my problem.

Thanks
Aman

Text130 = Format(Val(Text12) - Val(Text83),"#0.00")

Also try to give you field names a meaningful name, anyone trying to decypher your code would be pulling their hair out.

BTW 1.2 is the same as 1.20 if you have not set the properties correctly then Access will remove any trailing zeros.

Format:Fixed
Decimal Places:2

David

Thanks a lot Dcrake.

It worked perfectly.