Input Mask?

  • Thread starter Thread starter Chris LeFebvre
  • Start date Start date
C

Chris LeFebvre

One of my tables needs a field to identify the sex of an individual
so I have a once character field called (of course) Sex but I need to
limit input to either M/F and I can't figure out the correct input mask.

Thanks,

- Chris LeFebvre
 
I would create a lookup table with all possible values and then use a combo
box on my forms. I would limit the value to the list of genders.
 
One of my tables needs a field to identify the sex of an individual
so I have a once character field called (of course) Sex but I need to
limit input to either M/F and I can't figure out the correct input mask.

Thanks,

- Chris LeFebvre
Click to expand...

A Mask won't let you do this.

Instead consider using a Form with a combo box with a RowSourceType of
Value List and a RowSource of "M";"F"

In the table you can set the Validation Rule to

IN "M", "F"

to prohibit entry of "X" or "No thank you", but it won't help with the
data entry. Use a Form and the tools that the form provides.
 
Back
Top