Format Form Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Coffee - 18 May 2004 18:27 GMT

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

Reply to this Message

Charles Kenyon - 18 May 2004 19:16 GMT

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.

Signature

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.

> I want to make a form field format to a phone number,
> (###) ###-####. i have a fax cover sheet template and
[quoted text clipped - 3 lines]
>
> michael

Reply to this Message

Michael Coffee - 18 May 2004 19:34 GMT

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
[quoted text clipped - 9 lines]
>
>.

Reply to this Message

Charles Kenyon - 18 May 2004 20:18 GMT

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.)

Signature

> 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
[quoted text clipped - 32 lines]
> >
> >.

Reply to this Message

Charles Kenyon - 19 May 2004 19:15 GMT

Follow Cindy Meister's link first. It looks a lot simpler. Sorry about that.

Signature

> 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
[quoted text clipped - 32 lines]
> >
> >.

Reply to this Message

Cindy M -WordMVP- - 19 May 2004 15:43 GMT

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 :-)

Reply to this Message