>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?

You could brute-force it by using 9999.99 instead, but that means initializing the column in your app.

In a separate thread, Cindy Winegarden pointed out that sometimes you can use expressions like

0 + 0000.00 AS...

to work around this.

Regards.    Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up