The View Designer keeps removing my leading Zeros that I am using to create an editable view to be used to post data to a table for. I can put in an expression such as 0000.00 AS 'SomeField' into the Expression Builder. Then when I go to edit the View again it only as 0.00 AS 'SomeField' in the field.

I am using the leading zeros to provide for entering up to 4 digits prior to the decimal place in the field. If it only has one Zero in the field then I can only enter one number prior to the decimal place in the grid.

Any good ideas as to a work around?