How are Numeric fields with exact length used?
If I create a numeric field with exact length of 3, I can't enter any values unless the value has exactly 3 characters... I thought the exact length parameter would specify the maximum number of digits but it doesn't. If I want to enter a value of 1 the entry is rejected.
I can't see creating a field for values from 1-9, another for 10-99 and another for 100-999.
Am I missing something?