Input Mask?

[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

 

[Duane Hookom]

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.

 

[John Vinson]

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

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.