Autofill numbers

We use a form for entering numerical data. If one field has 1, and the next
has 2, when you tab to the 3rd, a 3 (or whatever pattern-- 2,4,6 or 4,8,12,
etc) will appear in the box, even if it's a text variable (e.g., comments).
How can I turn this off?

It is not something you can turn off. Whoever built your form did it. If
they are not around then you will need to reverse engineer the form.
Open in design view and check the properties of those text boxes.
If you can interpert the code enough to midify it then you could add a
condition that would look to a check box elsewhere on the form to control the
action. In other words if it is checked (default checked) perform the number
insertion, if unchecked do not insert number.

"NJTeresa" wrote:

We use a form for entering numerical data. If one field has 1, and the next
has 2, when you tab to the 3rd, a 3 (or whatever pattern-- 2,4,6 or 4,8,12,
etc) will appear in the box, even if it's a text variable (e.g., comments).
How can I turn this off?

On Tue, 21 Apr 2009 12:17:02 -0700, NJTeresa
wrote:

We use a form for entering numerical data. If one field has 1, and the next
has 2, when you tab to the 3rd, a 3 (or whatever pattern-- 2,4,6 or 4,8,12,
etc) will appear in the box, even if it's a text variable (e.g., comments).
How can I turn this off?

If it's a Datasheet form, in Access 2002 or 2003, you *can't*. It was a stupid
misfeature introduced by someone at Microsoft who apparently thought that a
relational table was a lot like a spreadsheet.

A getaround is to use a Continous Form rather than a datasheet.

Alternatively as Karl suggests, someone might have put some (equally unwise)
code in the form.
--

John W. Vinson [MVP]