Removing a constant area codes for telephone # in tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the tables I set up a field for phone numbers with a constant area code.
How do I remove this area code and make it available to enter any area code.
 
Go to the table properties and check the Default or Format for the field. If
that is not the problem then check the properties of the filed in the form.
 
Nancy

"Remove" as in permanently alter the field contents? If so, try using the
Find/Replace function and replace all the common area codes with a
zero-length string ("").

"Remove" as in permanently alter your table definition to include both an
area code field and a phone number field? If some phone numbers will have
area codes, some will not, and you want a choice, consider using two fields
instead of one.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top