>>Dear all, > >field format is 999,999,999,999.99 and checked (Negative). > >When this field dispalyed negative values shows in braces but some leading blanks. e.g. ( 10.000.00). it shouled be as (10,000.00) > >TIA >nafees
Are you talking about the Format Property (similar to InputMask)? In that case you can use 'T' to trim spaces before and after (similar to Alltrim)
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry