phone formatting

  • Thread starter Thread starter fishqqq
  • Start date Start date
F

fishqqq

Can someone please tell me how to format a text field that i have
combined other fields in so that the phone number has the following
format (999) 999-9999

design view =
=[First Name] & " " & [Last Name] & " PHONE:" & [PHONE] & " EXT:" &
[EXT] & " TOLL FREE:" & [TOLL FREE]

form view currently =
COLIN CHAN PHONE:4162461782 EXT:5513 TOLL FREE:

tks
Steve
 
=[First Name] & " " & [Last Name] & " PHONE:" &
Format([PHONE], "(@@@) @@@-@@@@") & " EXT:" &
[EXT] & " TOLL FREE:" & [TOLL FREE]
 
=[First Name] & " " & [Last Name] & " PHONE:" &
Format([PHONE], "(@@@) @@@-@@@@") & " EXT:" &
[EXT] & " TOLL FREE:" & [TOLL FREE]

--
_________

Sean Bailey

[email protected] said:
Can someone please tell me how to format a text field that i have
combined other fields in so that the phone number has the following
format  (999) 999-9999
Click to expand...
design view =
=[First Name] & " " & [Last Name] & " PHONE:" & [PHONE] & " EXT:" &
[EXT] & " TOLL FREE:" & [TOLL FREE]
Click to expand...
form view currently =
COLIN CHAN PHONE:4162461782 EXT:5513 TOLL FREE:
Click to expand...
tks
Steve
Click to expand...
Click to expand...

works great , Tks!!!
 
Back
Top