>>Hi, I want to show '0000' in a text box as the default value for a text box which should be holding a string, not a numeric value. However, even though I put in XXXX as the input mask, if I put 0000 in the Value field for the default, it truncates to just 0 (zero).
>>
>>As a point of interest if I put in 999-99-9999 as the input mask, and 000-00-0000 as the value, I get a nicely formatted ssn field. I suppose that is because the hyphens force the field to be a string.
>>
>>Sigh.
>>
>>any ideas?
>>
>>thanks. Hope everyone is enjoying DevCon! I know I would be if I were there.....
>>
>Hi Larry,
>
>Try using "9999" as the input mask. If the underlying data is character, this will allow the users to enter only numbers and any leading zeroes will be kept.
>
>hth,
Addendum, use 9999 (no quotes).
George
Ubi caritas et amor, deus ibi est