Hi Susan,
create a new query.
--use the table that has the Fax number in it
--drag the Fax number field onto the query grid
--select Query, Update query from the menu/toolbar
--in the Update To row type
"(" & Left$([tblAddress].[FaxNo],3) & ") " &
Mid$([tblAddress].[FaxNo],5)
--in the Criteria row type
Mid([tblAddress].[FaxNo],4,1)= "-"
Note: tblAddress is the name of the table with the fax no field, change it
to your table name
FaxNo is the name of the field with the fax no, change it to your field name
Run the update query
I created the above table and field and tested the update query.
Note: it is usually easier for maintenance if you store your fax numbers and
phone numbers in the table without any formatting or input masks and just
format the number how you want it to look when you are displaying it in the
form or exporting the query.
Jeanette Cunningham
Susan said:
While the input mask for a text based fax number database field works for
new
fax number entries, I need to update the EXISTING RECORDS to match this
format. For example, existing fax numbers are formatted as 123-456-789 and
needs to change to (123) 456-789.