Y and N entries

[Drisconsult]

Hello All



I have a one character field where the user can only enter Y or N in uppercase. I have no problem with the uppercase code but cannot get the Y or N code sorted out. The Y and N entries are then counted, no problem here. But the Y or N entries have got me baffled.

Terence
London

[NTC]

What is your question? It is not clear. If counts are no problem, then what is the problem that you refer to as 'entries' ?

[Drisconsult]

Hello
The user can only enter a Y or a N. no other characters are allowed.
Regards
Terence

[NTC]

Offer them a dropdown/combobox with just those 2 values in it. Make the actual textbox not visible. Put in vb into the AfterUpdate event of the combobox:
me.ActualTextBoxName=me.Comboboxname

[Drisconsult]

Hello
It was very kind of you to get back to me so quickly. Unfortuantely the database is for people with very little English, in fact Somalia school teachers in Puntland (yes there is such a place) and their helpers. We need to keep it as simple as possible, and dropdown combo boxes add to their difficulty.
Can this be done through a Validation Rule? I'm very rusty on this procedure having not used it for about four years now.
Regards
Terence
London