View Single Post
  #4  
Old May 18th, 2004, 08:18 PM
Charles Kenyon
external usenet poster
 
Posts: n/a
Default 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



.