View Single Post
 
Old 08-14-2015, 03:13 AM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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