Input mask specific letter or charater

[Guest]

I have a field that has a zip code. I have 1 extra space for putting at the
time a letter for a particular office. I want to have it where I can only
put a Y if I need to put in the letter. This is because I had moved around
my fields and now the field after this one starts with letters. If I can't
do letters is it possible to have it where I can only put in say a ; ? The
first 5 are numbers only and I don't want to use numbers incase I accidently
hit too many numbers it beeps at me.

 

[Rick B]

Not sure what you are asking.

Are you saying that you want to enter a ZIP code and then some letter in the
same field? That would be a bad idea. Database normalization would
indicate that each field should contain only one piece of information. If
you want to enter a code to indicate which office, then you would add a
field called "office".

Not sure what you are saying about putting a "Y" and the field after it and
all that. Please explain better.

 

[Guest]

Right now I have one office that uses the same zip code. So to assign a
piece of data to one manager I just have the zip. to assign the piece to the
other manager I put Y after the zip. This works fine. But to improve
inputing the data I rearranged the fields and now the field after this field
starts with letters, whereas before the next field was a date field. Having
the field being able to only leave blank or put in only a specific letter
there's a chance if you're not watching what you're doing you could
accidently put in the first letter of the next field by mistake. I just
wanted to make it easier but if it can't be done, we'll just have to be
careful putting in the data.