Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2004

Tip: Looking for answers? Try searching our database.

Required Form Fields for Templates

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jen - 07 Jan 2004 15:32 GMT
Has anyone used required fields in their Word templates?  
We would like to have certain fields required to be
completed prior to the sender automatically routing the
completed template to the next user.
Greg Maxey - 07 Jan 2004 15:46 GMT
Jen,

If you use a protected form you can run a variation of the
following macro run on exit from the mandatory field:

Sub ExitText1()
   With ActiveDocument.FormFields("Text1")
       If Len(.Result) = 0 Then
           Beep
           Application.OnTime When:=Now + TimeValue
("00:00:01"), Name:="GoBacktoText1"
               Set Balloon = Assistant.NewBalloon
               With Balloon
               .Text = "No Data!" & vbCr & "You must fill
in this FormField"
               .Button = msoButtonSetOK
               .Animation = msoAnimationBeginSpeaking
               .Show
               End With
       End If
   End With
End Sub

Sub GoBacktoText1()
   ActiveDocument.Bookmarks("Text1").Range.Fields
(1).Result.Select
End Sub

By variation, I mean you will have to make a macro and
change "Text1" to the bookmark name of each mandatory
field.


>-----Original Message-----
>Has anyone used required fields in their Word templates?  
>We would like to have certain fields required to be
>completed prior to the sender automatically routing the
>completed template to the next user.  
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.