Formatted numbers in a form

[s.booth]

I have a form which is based on a querry, all the formats for the fields in both the querry and form are set to fixed ie. 2 decimal places. My problem is when I select a field in the form the number loses its format and showes many more than the 2 decimal places wanted.

Any ideas????