Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Restrict Word Form Fields Without VBA

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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 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 two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

809 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