Field accepts 1 digit when typing, but pasting allows multiple digits

  • Thread starter Thread starter Ted Dutter
  • Start date Start date
T

Ted Dutter

Hi,

I encountered a weird problem today that I am hoping
someone could shed some light on.

My client uses a program that is an Access run-time
database. He has Windows XP and Office XP (including
Access 2002). He has the latest patches as of 9/19/2003
for both. I can tell the run-time database was not
created with Access 2002 because when I open it Access,
it wants to convert it.

There is a field in the database that is numeric.
However, when you try to type a number in the field, it
will only accept 1 digit. Any numbers typed after that
digit do not get entered into the field or displayed on
the screen. The cursor just blinks after the 1st digit
as if you had stopped typing.

However, if I type a number greater that 1 digit in
notepad. Then, copy and paste it into the field, the
number is accepted. This field is used in calculations,
so I can tell that it accepted the number correctly.

The company that produces the software is shrugging their
shoulders (they have seen it 4 times before, but have no
solution and say it is not their problem).

In summary: typing bad, pasting good.

Weird but true. Any suggestions?

Thanks,
Ted Dutter
 
Jus a guess, but likely it's related to the format of the textbox, code
running on one or more events of the textbox or form, or some other "hidden"
thing. Or it could be corruption of a strange type.

Very hard to troubleshoot without knowing more about the background of the
textbox and form.
 
What version is the runtime? If you can get into the design view of the
form, try turning off Allow Autocorrect in the field with the problem. In
Access 2000 and 97 this property is in the field properties window under the
Other tab.
This may or may not solve your problem.
 
Back
Top