Is there a way to ensure a field is displayed in a certain format? ie.

if you enter a phone number 8765552212, it displays as (876) 555-2212

appreciate the help in advance.

Look up the Filter function in the online Help. There is an example of phone formatting.

Look at the Phone Format file on this site:

http://datatude.net/dl.htm