Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 08-14-2015, 03:13 AM
macropod's Avatar
macropod macropod is offline Suggestions needed for Questionnaire Form Windows 7 64bit Suggestions needed for Questionnaire Form Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

As I suspected in my previous reply, your form uses a mix of formfields and content controls. You should use one or the other, not both.

If you want to use formfields, they have no equivalent of the date-picker content control - only a date format for input validation.

Some of your questions also have checkboxes but there's nothing to prevent someone checking both - or leaving both unchecked. Instead of checkboxes, I'd suggest using Dropdowns with the appropriate options (e.g. for gender - male & female).

Your address 'field' is also far too small for the amount of data a respondent might be expected to input; I'd suggest separate 'fields' to cater for:
• Apartment #
• Property name
• Street # and name
• City
• State
• post/zip code
You might consider taking the same approach to some of your other fields, also. Doing so facilitates the export of the data to a database, which I presume is what will occur at some stage.

Given your desire to use the date-picker content control, you should therefore replace all the fields with the corresponding content controls.

The content cannot be locked post-input without the use of a macro. However, there is no need for the form itself to contain one. Only the template upon which it is based needs contain the macro. Once returned to the form's 'owner' the macro, which could be made to run automatically, could lock all the inputs to prevent editing. The same macro could validate the inputs and report any exceptions - which would be useful for follow-up purposes.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Form, add fillable bullets as needed. jonchimento Word 2 04-17-2015 12:30 PM
Create New Document with responses from a questionnaire. singerbatfink Word VBA 2 02-25-2015 04:24 AM
Spellcheck macro for protected form fields needed rharvey1215 Word 12 03-31-2014 06:47 PM
Suggestions needed for Questionnaire Form How do you turn on/off the word suggestions? JeffL Word 4 12-28-2013 01:12 PM
Suggestions needed for Questionnaire Form Customer questionnaire Dean PowerPoint 5 05-04-2011 04:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:34 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