Sarah
That really requires 2 fields. Even the basic Normal Form dictates only one element be stored in a field. Reports are such that if the phone number needs the formatting you use Format(), not an input mask.
Textbox ControlSource:
=[PersonsName] & " " & Format([PhoneNum],"(999) 000-0000")
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, "novice012000" wrote:
>
> Is there any way to create an input mask for a telephone number and text in one field on a report . The input mask for the telephone number is \(999") "000\-0000" ext "99999;;_"", I would like to print a name before the tel#. I dont want to use 2 fields todo this, because I want them separated by only one space and since the name can be a variable length I can not use 2 fields. How to I add a text mask to the beginning of the tel# mask.? I tried using '?', but it did not work.
> Thanks in advance for any help.
>
> Sarah
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar