"REPLACE IN FIELD"

[T.Korner]

I am using ACCESS 2000.

I have a phone number database in which the phone records
appear in this format: 0000000000 (Area code + Number with
no spaces, dashes or brackets... 10 digits in all.)

I want to convert all records to the following format:
000-000-000 (Area code, then a dash; then the three digit
phone prefix, then a dash; then the final four digits of
the phone numbers)

I have tried this in the "REPLACE IN FIELD" window
using "wild cards" but I need to know exactly what to put
into the 'Find What' space... and what to put into the
'Replace With" space.

 

[Chris2]

format("2128675309","###-###-####")

 

[John Vinson]

I am using ACCESS 2000.

I have a phone number database in which the phone records
appear in this format: 0000000000 (Area code + Number with
no spaces, dashes or brackets... 10 digits in all.)

I want to convert all records to the following format:
000-000-000 (Area code, then a dash; then the three digit
phone prefix, then a dash; then the final four digits of
the phone numbers)

I have tried this in the "REPLACE IN FIELD" window
using "wild cards" but I need to know exactly what to put
into the 'Find What' space... and what to put into the
'Replace With" space.

You can *display* this field with the hyphens without actually
*storing* the hyphens - just set the Input Mask to

000-000-0000

If you actually want to update it, Replace won't work because you
don't have anything to replace. Instead Update To

Left([Phone], 3) & "-" & Mid([Phone], 4, 3) & "-" & Right([Phone], 4)