asked on

Restrict Word Form Fields Without VBA

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.

Brian Pierce

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

Fylar

ASKER

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

ASKER CERTIFIED SOLUTION

Brian Pierce

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Fylar

ASKER

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

Fylar

ASKER

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