New table using the wizard, the field formats are not correct.

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

Guest

When I chose home phone, it is coming up as a text field and not a numeric
field.
 
It is a text field so you can use an Input Mask to display the field in the
format you want. Since you won't be doing any calculations on a phone number
field, this is ok...
 
you can change it to a number field if you want, but i wouldn't bother. the
general rule of thumb is to use number fields for values which will be used
in mathematical calculations (and i use number fields for values that need
to be sorted numerically rather than as text) - and obviously neither rule
applies to phone numbers (or to zip codes).

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top