Format Problem

[Guest]

I have my format set to 000 000
Yet i have come across a problem where i'll have to have (000) 00 0000
how do i change a single format without changing all the others?

 

[Joseph Meehan]

I have my format set to 000 000
Yet i have come across a problem where i'll have to have (000) 00 0000
how do i change a single format without changing all the others?

You can't change a format for a specific record. I question why you are
using numbers here and not using text. With text you don't need formats,
unless you are using it as a verification technique.