Community
Showing results for 
Search instead for 
Do you mean 
Reply

Field Format

New Member
Posts: 6
Country: Australia

Field Format

I want a field to have the following format, ## ### ### ### e.g 34 545 676 769.

It is a Company Character field, Allows Blanks,  Field Length 14.

When I save it and insert a new Contact the format isn't there e.g. 34545676769.

Any Ideas?

Colin

Administrator
Posts: 1,372
Country: United_Kingdom

Re: Field Format

Have you set the field format in the Define Fields section?

Tools > Define Fields > Edit Field > (page 2) Field Format

Entering the format as ## ### ### ### would ensure only numbers could be entered and preserve the format.