how do i make a phone number in a form/table

[Guest]

I am a novice on Access and am trying to work through a table, but cannot
figure out how to use the standard (000) 000-0000 format in my form/table.
Can anyone help? Thanks.

 

[Niklas Östergren]

Hi!

In tables you store data and in forms and reports yu show the stored data
for the user. In forms the user can edit, add and delete records as well.
And the most common thing with what you are trying to do (I think), is to
format the stored data when the data is presented for the user, right?

So:

Store the data in the tables just like 0000000000 (datatype long) and set
format property of a control in either a form or report to (&&&") "&&&" -
"&&&&

Hope this helps you out!

// Niklas

 

[Van T. Dinh]

Check Access Help on InputMask.