Format Field

[Jeffrey Holzenthal]

I would like to have all numbers with a length of <2 prefixed by a zero.

01

02

03

How could pre-pend the zero when the user exits the field?

Thanks,

jdholzen

[Vaughan]

Numbers (ie, data of type = number) cannot be prefixed with zeros. Text can.

The general way of adding leading zeros (or other characters) is:

Right( "00" & field ; 2 )

[Jeffrey Holzenthal]

Hi,

Thank you, but I would like for the field to be modifiable to the user. Is this possible with a calculation? Will I need a script here?

[comment]

I prefer:

SerialIncrement ( "00" ; field )

The difference is that numbers above 99 are not truncated.

[comment]

Make your field auto-enter the calculation, replacing existing value.