Error on numerical input after certain value. (1 Viewer)

foshizzle

Registered User.
Local time
Today, 14:21
Joined
Nov 27, 2013
Messages
277
I just realized there is a problem with my form. It seems that when I input any number past 32767, I get the error below.

Run-time error '3421':
Data type conversion error.
(Please see screenshots).

The Odometer field is defined as a number in the table. Please let me know if you need more info - I'm not sure where to look.
Thanks
 

Attachments

  • error_0.jpg
    error_0.jpg
    99.9 KB · Views: 89
  • error_1.jpg
    error_1.jpg
    86 KB · Views: 69
  • error_2.jpg
    error_2.jpg
    79 KB · Views: 76

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 05:21
Joined
Jan 20, 2009
Messages
12,849
You have an Integer field and it is being fed a value that exceeds the maximum. (2^15 - 1)

Change the field datatype to Long.
 

Users who are viewing this thread

Top Bottom