Newbies Jeffrey Holzenthal Posted September 22, 2008 Newbies Share Posted September 22, 2008 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 Link to comment Share on other sites More sharing options...
Vaughan Posted September 22, 2008 Share Posted September 22, 2008 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 ) Link to comment Share on other sites More sharing options...
Newbies Jeffrey Holzenthal Posted September 22, 2008 Author Newbies Share Posted September 22, 2008 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? Link to comment Share on other sites More sharing options...
comment Posted September 22, 2008 Share Posted September 22, 2008 I prefer: SerialIncrement ( "00" ; field ) The difference is that numbers above 99 are not truncated. Link to comment Share on other sites More sharing options...
comment Posted September 22, 2008 Share Posted September 22, 2008 Make your field auto-enter the calculation, replacing existing value. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5708 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now