Middle initials.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a very short form with first name, middle initial, last name,
business address and phone numbers. When I try to input data and the person
has a middle initial, I cannot input it because the computer beeps and won't
let me.

What happens is when I first click in the first name field, the MI field
gets selected with "#N." already input. Then when I click on it to put in a
middle initial, I just get a beep and I'm forced to move on to the next field
which is the last name. I have formatted the MI field for 3 spaces.

Any ideas as to what is going on here?
 
#N is probably part of an error notice. Rather than trying to format the
field you may do better limiting its size to three characters (or whatever
length you need) in table design view.
 
I think the key is...
What happens is when I first click in the first name field, the MI field
gets selected with "#N." already input.
Click to expand...
Looks as though you have an Input Mask, or perhaps a Default Value
entered for that field. When you "click" in with the mouse, your
positioning the cursor at the end of the text or mask that's there, so field
length won't let you enter any more characters.
Try this... "tab" into the field instead of mouse clicking in... Tabbing
in causes all existing data in the field to be selected, and overwritten,
and should allow you to enter all 3 chars.

Better yet, make the MI field 1 character long, and drop the Input Mask.
No need for an Input Mask for just one character.
If you must have an InputMask, just ? (any letter/not required)
should do it.
hth
Al Camp
 
Sorry I said Format. What I did was limit the field size to three
characters. And there is no input mask on this field. Thanks.
 
Thank you for responding. I do have Default Values entered for two fields
several fields down, but not on the MI field, just City and State, as all the
entered values are from one particular city. Also, I do use the Tab key for
entering data, not just the mouse.

One thing I noticed was that when I continually pressed the Enter key to get
to a new record, the cursor does not blink in the first field of the new
record. Why is that?
 
Back
Top