Solved

Restrict Word Form Fields Without VBA

Posted on 2007-03-28
5
899 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

ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

Question has a verified solution.

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

Suggested Solutions

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
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…

803 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