If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Format Form Field
I want to make a form field format to a phone number,
(###) ###-####. i have a fax cover sheet template and want to only enter in the numbers and have word put in the dashes and parenthesies. Any help would be greatly appreciated. michael |
#2
|
|||
|
|||
Format Form Field
I suspect you'll need an on-entry macro that will pull up a userform for
this purpose. I'm assuming you are talking about a protected online form. If not, perhaps a macrobutton field that would pull up such a userform. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Michael Coffee" wrote in message ... I want to make a form field format to a phone number, (###) ###-####. i have a fax cover sheet template and want to only enter in the numbers and have word put in the dashes and parenthesies. Any help would be greatly appreciated. michael |
#3
|
|||
|
|||
Format Form Field
It is not an online form, i figured i would have to write
a macro for that. where could i go to get the basics on writing a macro of this sort, i assume it would be a relatively simple macro. -----Original Message----- I suspect you'll need an on-entry macro that will pull up a userform for this purpose. I'm assuming you are talking about a protected online form. If not, perhaps a macrobutton field that would pull up such a userform. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- ------- -- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Michael Coffee" wrote in message ... I want to make a form field format to a phone number, (###) ###-####. i have a fax cover sheet template and want to only enter in the numbers and have word put in the dashes and parenthesies. Any help would be greatly appreciated. michael . |
#4
|
|||
|
|||
Format Form Field
It depends on your definition of relatively simple...
The macro could be as little as: Sub PhoneNumberMacro() Dim myForm As frmPhoneNumber Set myForm = New frmPhoneNumber myForm.Show Unload myForm Set myForm = Nothing End Sub Of course, that assumes you have the userform "frmPhoneNumber." http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm Its all a question of how much work you are willing to go through to help people type a phone number in a fax form. (You could have the userform gather all the information for the Fax Cover sheet header just about as easily. OTOH, you could use macrobutton fields in a table as prompts the way the built-in fax forms do, or both.) -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Michael Coffee" wrote in message ... It is not an online form, i figured i would have to write a macro for that. where could i go to get the basics on writing a macro of this sort, i assume it would be a relatively simple macro. -----Original Message----- I suspect you'll need an on-entry macro that will pull up a userform for this purpose. I'm assuming you are talking about a protected online form. If not, perhaps a macrobutton field that would pull up such a userform. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- ------- -- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Michael Coffee" wrote in message ... I want to make a form field format to a phone number, (###) ###-####. i have a fax cover sheet template and want to only enter in the numbers and have word put in the dashes and parenthesies. Any help would be greatly appreciated. michael . |
#5
|
|||
|
|||
Format Form Field
Hi Michael,
I want to make a form field format to a phone number, (###) ###-####. i have a fax cover sheet template and want to only enter in the numbers and have word put in the dashes and parenthesies. Some versions of Word will do this for you, if you enter the Format in the form field options. Which version do you have? Otherwise, you can use a macro that triggers on exit from the form field. Here's a Knowledge Base article that describes, generally, how to go about doing this http://support.microsoft.com?kbid=160988 Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#6
|
|||
|
|||
Format Form Field
Follow Cindy Meister's link first. It looks a lot simpler. Sorry about that.
-- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Michael Coffee" wrote in message ... It is not an online form, i figured i would have to write a macro for that. where could i go to get the basics on writing a macro of this sort, i assume it would be a relatively simple macro. -----Original Message----- I suspect you'll need an on-entry macro that will pull up a userform for this purpose. I'm assuming you are talking about a protected online form. If not, perhaps a macrobutton field that would pull up such a userform. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- ------- -- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Michael Coffee" wrote in message ... I want to make a form field format to a phone number, (###) ###-####. i have a fax cover sheet template and want to only enter in the numbers and have word put in the dashes and parenthesies. Any help would be greatly appreciated. michael . |
Thread Tools | |
Display Modes | |
|
|