Inputmask?

B

BC

I want to limit the operator input for a field where data is input via a
form to one of three charactes (The capital letters) X, O, or I
What is the best way to do this?
 
G

Gary Miller

One good way is to give them a combobox with those choices
and LimitToList set to Yes.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
T

tina

the quickest way to set it up is to

1. open the form in design view
2. select the control
3. set a validation rule (in the Properties box), such as
X or O or I Or Is Null (don't use the Is Null if data is
required in this field for every record)
4. set a validation text to explain the data entry
requirement to your user (if you don't, a message box will
pop up anyway, and the default message is not user
friendly)

hth
 
B

BC

Does this force it to capital letterss?
the quickest way to set it up is to

1. open the form in design view
2. select the control
3. set a validation rule (in the Properties box), such as
X or O or I Or Is Null (don't use the Is Null if data is
required in this field for every record)
4. set a validation text to explain the data entry
requirement to your user (if you don't, a message box will
pop up anyway, and the default message is not user
friendly)

hth




is input via a


O, or I
 
T

tina

no. suggest you "show caps" rather than worrying about
forcing "enter caps".
showing the data as capital letters is a formatting issue.
in form design view, select the control. in the Properties
box, on the Format line, type a "greater than" symbol (>).
use the same symbol in the same place in any report you
build that shows that field, and that's all you have to do.
 
R

Rick Brandt

tina said:
no. suggest you "show caps" rather than worrying about
forcing "enter caps".
showing the data as capital letters is a formatting issue.

Unless you are using a back end database that is case-sensitive. Then it
might matter a greate deal that all caps is actually what is stored.
 
B

BC

I do not know what a back end database is ... I'm using Access 2000.
The XOI field will be used for logical operations and I wanted to
simplify any logical comparisons and at the same time prefer that the
letters be displayed as caps. They actually stand for Open(O) Closed(X)
and Information(I).
 
T

tina

Rick points out a valid consideration, BC. but if your
database does not contain any linked tables, you don't
need to worry about it in this instance. if that's the
case, just set the format as i explained before.
if, on the other hand, you think there is or may be a need
to have the actual data in this field saved as capital
letters rather than small letters - then you'd be better
off to use a combobox in the form, as Gary suggested in an
earlier post. :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top