Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2024, 09:15 AM
ShellR ShellR is offline Need help with clearing content field values + allow user to sign + submit  word form once completed Windows 10 Need help with clearing content field values + allow user to sign + submit  word form once completed Office 2019
Novice
Need help with clearing content field values + allow user to sign + submit  word form once completed
 
Join Date: Aug 2024
Posts: 17
ShellR is on a distinguished road
Default Need help with clearing content field values + allow user to sign + submit word form once completed


I am hoping someone could assist me with this.
I've created a word form (to also be used on mobile); it has multiple content controls (text, checkbox, dropdown lists, date picker). The form is protected to allow form filling only (with no password). This is what I need it to do:

1. on open, all the content controls fields values needs to be blank...although, I suppose it can be done once the user submits it?
2. I want the form to check the values to make sure they are the proper format. for example, in the name field, I want to make sure there are no numbers entered and, of course check that no field value is blank. Is there a way to check each field as the user enters them? or, better yet set the property for each field( which i tried to do, but not able to find the option to do so)
3. once the form is completed, there is a section to sign it electronically (which only worked for me in unprotected mode)... Is there a reason for this?
4. I then want to give the user the option to submit or print the form

Thank you so much in advance. I haven't done this type of work for years now. I am definitely a lot rusty!!

Last edited by ShellR; 08-08-2024 at 05:45 AM. Reason: corrected wording to specify content control values
Reply With Quote
  #2  
Old 08-08-2024, 12:46 AM
gmayor's Avatar
gmayor gmayor is offline Need help with clearing content field values + allow user to sign + submit  word form once completed Windows 10 Need help with clearing content field values + allow user to sign + submit  word form once completed Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Forms using content controls do not need to be protected for forms. If you want to protect the areas that are not fields, then mark the fields with 'Editors' and protect as read only. You may find Insert Content Control Add-In useful in making the changes.

You can validate fields using macros, but this requires the use of macros and you cannot force the use of macros.
Frankly the best approach for such a form is to create a PDF form, but for this you will require software, such as Acrobat, capable of creating such a form.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 08-08-2024, 01:38 AM
Italophile Italophile is offline Need help with clearing content field values + allow user to sign + submit  word form once completed Windows 11 Need help with clearing content field values + allow user to sign + submit  word form once completed Office 2021
Expert
 
Join Date: Mar 2022
Posts: 554
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default

If you’re expecting the form to be used in the online version of Word then VBA isn’t going to help you as it is only available in the desktop version.
Reply With Quote
  #4  
Old 08-08-2024, 05:50 AM
ShellR ShellR is offline Need help with clearing content field values + allow user to sign + submit  word form once completed Windows 10 Need help with clearing content field values + allow user to sign + submit  word form once completed Office 2019
Novice
Need help with clearing content field values + allow user to sign + submit  word form once completed
 
Join Date: Aug 2024
Posts: 17
ShellR is on a distinguished road
Default Need help with clearing content field values + allow user to sign + submit word form once completed

Correction to my last post (my apologies):

I am hoping someone could assist me with this.
I've created a word form (to also be used on mobile); it has multiple content controls (text, checkbox, dropdown lists, date picker). The form is protected to allow form filling only (with no password). This is what I need it to do:

1. on open, all the content controls fields values needs to be blank...although, I suppose it can be done once the user submits it?
2. I want the form to check the values to make sure they are the proper format. for example, in the name field, I want to make sure there are no numbers entered and, of course check that no field value is blank. Is there a way to check each field as the user enters them? or, better yet set the property for each field( which i tried to do, but not able to find the option to do so)
3. once the form is completed, there is a section to sign it electronically (which only worked for me in unprotected mode)... Is there a reason for this?
4. I then want to give the user the option to submit or print the form
Reply With Quote
  #5  
Old 08-08-2024, 07:20 AM
Italophile Italophile is offline Need help with clearing content field values + allow user to sign + submit  word form once completed Windows 11 Need help with clearing content field values + allow user to sign + submit  word form once completed Office 2021
Expert
 
Join Date: Mar 2022
Posts: 554
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default

VBA is only available in the desktop version of Word, not in the mobile apps or the web version.
The usual advice would be to use a document template (dotx) as this will always give you an initialised document, but I don’t know if that will work with the mobile apps either as I don’t use them.
Reply With Quote
  #6  
Old 08-08-2024, 06:21 PM
ShellR ShellR is offline Need help with clearing content field values + allow user to sign + submit  word form once completed Windows 10 Need help with clearing content field values + allow user to sign + submit  word form once completed Office 2019
Novice
Need help with clearing content field values + allow user to sign + submit  word form once completed
 
Join Date: Aug 2024
Posts: 17
ShellR is on a distinguished road
Default

thank you. Any suggestions for VBA code that I can use for desktop for now? We can figure out the rest at a later date.

thank you
Reply With Quote
  #7  
Old 08-09-2024, 06:29 AM
gmayor's Avatar
gmayor gmayor is offline Need help with clearing content field values + allow user to sign + submit  word form once completed Windows 10 Need help with clearing content field values + allow user to sign + submit  word form once completed Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

If you create a macro enabled template and create documents from it, the documents will match the template. They will not have old data in the fields.

For validation of content in those fields my old friend Greg Maxey has a web page that covers this - see Validate Content Controls Entries. The code he illustrates goes in the template.

This, as I suggested earlier, is difficult to employ for third party use and a PDF form makes more sense.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Tags
content controls, signatures, word forms



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum of numbers regardless of sign in a Form Field unistate Word 1 12-19-2023 08:15 PM
Clear all content controls (Text, dropdown) AND change option button values to FALSE in MS Word Form Janet D Word VBA 7 01-14-2023 02:36 AM
Content Control Boxes Print on Completed Form Lambchop6 Word 2 04-05-2017 05:16 PM
Need help with clearing content field values + allow user to sign + submit  word form once completed Content Control Field Names/Titles Word Form shammi_raj Word VBA 3 03-10-2016 02:54 AM
Need help with clearing content field values + allow user to sign + submit  word form once completed Updating field codes without clearing form fields wwwKris Word 1 08-29-2014 07:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft