Unanswered: Display any leading zeros in numeric field
I have a numeric field that is 5 digits. The customer requests that any leading zeros be retained and displayed. I know the best way would be a text field as no calculation are to be done on this field but they want it to be numeric. How can I display the "LOCID" field to show any leading zeros? I mean to display it only if it was entered. Maybe an input mask or formatting?
One thing to consider is on a report how that field will sort (you may not need to sort it). With leading zeroes it will sort as an alpha-numeric and not as a numeric. To see what I mean you can add these values to a test table as Text fields (0124,123,00125) and see how they sort.