Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-10-2024, 11:13 AM
viewtost viewtost is offline Ensure that a form has been completed Windows 10 Ensure that a form has been completed Office 2019
Advanced Beginner
Ensure that a form has been completed
 
Join Date: Jul 2021
Posts: 35
viewtost is on a distinguished road
Default Ensure that a form has been completed

Hello all,



I hope you are well.

I have a form with three different lines:

Name: It´s a rich text content control
Surname: It´s a rich text content control
Start date: It´s a date picker content control

I would like to write a macro that checks if all the fields of the form (name, surname, and start date) have been filled. If they have been filled in, I want a message to pop up saying “Ready to be printed”; if any of the fields have not been completed, I want a message to pop up saying “Please complete all the fields”.

Then, when people fill in the form, they can run the macro to ensure they haven't missed any fields before printing it out. The form will contain more fields in the future, so I would like a macro that could work with any new fields that I may add to the form.

For better understanding, I am attaching an example of the form

Thanks!
Attached Files
File Type: docm Example of form.docm (18.8 KB, 3 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Content Control Boxes Print on Completed Form Lambchop6 Word 2 04-05-2017 05:16 PM
Ensure that a form has been completed Disable email function of command button if all form fields are not completed derajlance Word VBA 10 05-11-2016 01:05 PM
Ensure that a form has been completed ensure I have an 8.5x11 sheet Taylor Word 3 10-09-2011 12:39 AM
Ensure that a form has been completed How to ensure that each line ends only at the margin sparemejava Word 9 02-06-2011 03:21 PM
Convert a completed form to verbalized text tsttm Word 0 07-09-2010 05:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:51 PM.


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