>Hi Folks.
>
>The "R" Format property. You know, the thing that applies a format mask to data as specified in the InputMask property. The Builders love it. I don't. Phone numbers, for example. If the data is stored as (999) 999-9999 and you use (999) 999-9999 as your InputMask and have R in the Format, you end up with a display that looks like "((99) 9) 99", or something to that effect.
>
>Frankly, I like to store data as formatted so that I don't have to worry about formatting it from whatever front-end I get it from. So the "R" is worse than useless for me.
>
>What do y'all think?
I personally like to store the data unformatted.
And how your users will do the Incremental Search on your formatted phone number field - entering the brackets and spaces too? :)
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison