phone formatting "fishqqq[ at ]hotmail.com" <fishqqq[ at ]hotmail.com> 11/26/2008 8:59:31 PM 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

RE: phone formatting Beetle 11/26/2008 9:56:01 PM =[First Name] & " " & [Last Name] & " PHONE:" & Format([PHONE], "([ at ][ at ][ at ]) [ at ][ at ][ at ]-[ at ][ at ][ at ][ at ]") & " EXT:" & [EXT] & " TOLL FREE:" & [TOLL FREE] -- _________ Sean Bailey "fishqqq[ at ]hotmail.com" wrote: [Quoted Text] > > 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 >

Re: phone formatting "fishqqq[ at ]hotmail.com" <fishqqq[ at ]hotmail.com> 11/26/2008 10:07:59 PM On Nov 26, 4:56 pm, Beetle <Bee...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > =[First Name] & " " & [Last Name] & " PHONE:" & > Format([PHONE], "([ at ][ at ][ at ]) [ at ][ at ][ at ]-[ at ][ at ][ at ][ at ]") & " EXT:" & > [EXT] & " TOLL FREE:" & [TOLL FREE] > > -- > _________ > > Sean Bailey > > "fish...[ at ]hotmail.com" wrote: > > > 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 works great , Tks!!!