Rajesh

Just a little note of caution when formatting phone no. fields. Due to the proliferation of mobile (cell) phones, and the almost exponetial growth in subscribers of land-lines, we've found in the UK that we ran out of space with set formats.

e.g.

Most UK numbers were like 0XXX XXXXXX. In the 90's these were all changed to 01XXX XXXXXX

Many big cities had the format: (city - local exchange - number) 0X1 XXX XXXX, and London had the format:
01 XXX XXXX.
Most cities were changed to 01X1 XXX XXXX. London had to be split into: 0181 XXX XXXX and 0171 XXX XXXX (for inner and outer London). Later these were changed (respectively) to: 020 8XXX XXXX and 020 7XXX XXXX.

So "hard-coding" phone no. formats may lead to a legacy problem when your exchanges become full.

Terry

>Hello all
>
>Is there a way to format a column in the grid conditionally. Suppose I have a phone # field which may be empty in some cases as well. I want to use (XXX)XXX-XXXX where this field is not empty and a blank where it is empty. It shows ( ) - where field is blank. How to avoid it.
>
>Thanks
>
>Rajesh