Solved

Restrict Word Form Fields Without VBA

Posted on 2007-03-28
5
897 Views
Last Modified: 2008-02-26
Using MS Word 2003.

I want to enforce certain choices of values on a MS Word form such that it cannot be typed into.

I'd like to achieve something similar to the Data Validation within MS Excel, without embedding Excel (as it becomes uneditable when protection is applied) and without using VBA, so it can open on client computers without security warnings.

Is this possible?

If so, how?

100 Bonus Points will be given for an appropriate solution.
0
Comment
Question by:Fylar
  • 3
  • 2
5 Comments
 
LVL 70

Expert Comment

by:KCTS
Comment Utility
You can use a form. Forns are best laid out in a table format in my experience but this is not essential.
To create a form tou first need to make sure the forms toolbar is visible. you can switch it in with
View->Toolbars and make sure forms is ticked.

With the forms toolbars you can add different types of field, checkboxes which can be checked or not checked.

Textboxes in which you can restrict what is typed to meet your criteria

Listboxes where people can chose from a list of options
You simply use the toolar to select which sort of field you want and place it on the form
You can then right click on the field to set its properties and define what options tou want.
When you are all done you must LOCK the form so that it can be used
see http://www.microsoft.com/technet/prodtechnol/office/office2000/tips/msw9741.mspx
0
 
LVL 1

Author Comment

by:Fylar
Comment Utility
Hi KCTS.

Thanks for your response.

We already have a form with a listbox / drop down. What we are having trouble with is enforcing a strict set of values for that field.

For example, say we had a field called fruit, and in the drop down list there are apples, oranges & bananas.
We do not want the user to be able to type in watermelon.
Currently, we seem to be unable to stop the user from typing in something completely different.


Cheers,

Fylar


0
 
LVL 70

Accepted Solution

by:
KCTS earned 50 total points
Comment Utility
I just tried it on Word 2003 to make sure. If you create a drop-down box and enter apples, oranges and bananas as drop- down items then once the form is locked only the options in the list can be selected and the user cannot type in anything else.
0
 
LVL 1

Author Comment

by:Fylar
Comment Utility
Urk. I'm discovering the problem of asking a question on behalf of a colleague. I mis-interpreted his requirements. I thought that it sounded too simple.

What he was actually wanting was a way of ensuring that a choice is made. Such that the user cannot leave it blank.

With the previous example, the user has to select one of apples oranges or bananas, and they must make a choice.

Is this possible without using  macro?

Cheers,

Fylar

0
 
LVL 1

Author Comment

by:Fylar
Comment Utility
Ok, I expect that there's probably not a solution to this question with its requirements as is. I've accepted your answer to say thanks for the effort.

Cheers,

Fylar
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now