subform 'line total' figure error

[rvd48]

in my system, i have Quanity X price = Line Total. but the problem is that the line total keeps on coming up as a whole number everytime. e.g.

Price *Quantity = Line Total.
£1.67 * 1 = £2.00


my 'line total' code is Clng(([Quantity]*[UnitPrice])) . do i need to change my code, or would i need to change the properties in the form?

 

[rvd48]

i've just removed: 'Clng' from the code and now it seems to work, will this have a negative effective?

 

[neileg]

will this have a negative effective?

If this is an unbound text box, it will display the correct value when you view existing data.