I have some global fields where numbers are to be keyed in by the user ... I want to make sure that they type
'01' instead of '1'
'02' instead of '2'
How can I force the user to do so when numbers are betwen 1 - 9 ?
Autoenter calculated value,
Case ( Length(Self) < 2 ; "0" & Self; Self)
uncheck "do not replace existing value of field (if any)"
Thanks ! ... I was using a calculated field for the same thing... it wasn't working
Should be TEXT field not number field.
-- sent from myPhone --
I am using number field and it seems to be working ...
OK, when the user clicks in the field (if allowed), does it show "0x"? or just the number? And if the data is needed elsewhere (such as with export or other publishing), does it behave as number or text?
Yes, you can enter text into a number field, but it can behave differently. My concern is how is the number-with-leading-zero used.
When a user clicks into the field it is showing 0x not just the number ... I think I need it to behave as a number in other parts of the database eg. a script .
Is a preceding 0 before a number eg. 01 considered as text being entered into a number field ?
I know that zip code fields typically are TEXT, so they can retain leading zero(s). The usage of the value elsewhere (even in FM scripting) may be the difference.
Retrieving data ...