Solved

Restrict Word Form Fields Without VBA

Posted on 2007-03-28
5
898 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
ID: 18806426
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
ID: 18806508
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
ID: 18808671
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
ID: 18813088
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
ID: 18929034
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

947 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

21 Experts available now in Live!

Get 1:1 Help Now