Number formating

[johnrh]

I have a number iield which is currently formated to two decimal places. I need it to show a leading zero if the data is less than 10.

For example.

Suppose the data is 1.45

I need the format to show 01.45. However if the data is greater than 10 then I just want it to show the data - i.e. no additional zeros.

Anybody goy a suggestion to what should be an easy formating problem?

Thanks

[CobaltSky]

One answer to this would be to create a calculating field to display the number of the desired format, turn 'Allow Entry into field' off, and stack it on top of your existing number field. That way, when you tab to the field or click into it, the original value will be displayed (and may be edited), but at all other times, the calc value will be what is displayed.

In this respect, the functionality will appear to be the same as an auto-format applied to the field, but the difference is that you get total control over what is displayed. If the calculation is unstored, the impact on file size will be negligible.

You could, for instance, create and use a formula along the lines of:

Right("00" & Int(Number), Max(2, Length((Int(Number))))) & "." & Right(((Round(Number - Int(Number), 2) * 100) + 100), 2)

Which would permit your number to exceed 99, but would nevertheless place a leading zero on all numbers less than 10, plus would extend to two decimal places for all cases (including zeros - so 0 would be displayed as 00.00).

As well as turning 'Allow entry' off for the calculation field, you should ensure that the calculation field has 'Leave data formatted as entered' (if you have chosen a result type of number). A text 'result type' for the calc would be preferable in most cases.

[johnrh]

Your answer works an absolute treat. Thanks for the speedy reply

John