Form woes

[nathan]

Good morning folks.

Here at work, we have an access db used in HR. They have a form where
they add in new employees. In the 'badge number' (employee #) text box
they have always entered 4 digit badges, now we are up to 5 and even 6
digits, this is where the problem comes in.

This box seems to want to accept _only_ 4 digits, and i get an error
when i try to click into another text box if there ar 5-6 characters
in it.

"The value you entered isn't valid for this field" "(for example, you
may have entered text in a numeric field that is larger than the field
size setting permits)"

I did not create this db, and have never worked on it before, it's
just something that i got assigned to me.

Any suggestions as to where i should look for the setting to allow me
to enter 5-6 characters would be very appreciated, these post-it notes
my boss keeps putting on my monitor about it are piling up! Thanks
folks.

[Tom van Stiphout]

On 5 Nov 2003 05:51:11 -0800, n4****@hushmail.com (nathan) wrote:

Check the underlying table. I think it is likely the badge number
field either is a Number, subtype=Integer (which restricts to 32767),
or it is Text, length=4.
Change to either Long Integer or Text(6) and you should be back in
business.

If not, then there is some extra validation for this field in the code
behind it. Inspect the <Field>_BeforeUpdate code and the
<Form>_BeforeUpdate code.

-Tom.

Good morning folks.

Here at work, we have an access db used in HR. They have a form where
they add in new employees. In the 'badge number' (employee #) text box
they have always entered 4 digit badges, now we are up to 5 and even 6
digits, this is where the problem comes in.

This box seems to want to accept _only_ 4 digits, and i get an error
when i try to click into another text box if there ar 5-6 characters
in it.

"The value you entered isn't valid for this field" "(for example, you
may have entered text in a numeric field that is larger than the field
size setting permits)"

I did not create this db, and have never worked on it before, it's
just something that i got assigned to me.

Any suggestions as to where i should look for the setting to allow me
to enter 5-6 characters would be very appreciated, these post-it notes
my boss keeps putting on my monitor about it are piling up! Thanks
folks.