Overflow Error

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

Guest

After user changes updates the data in a date field/control on my form, it
calls WorkingDays2 in order to compare the two dates and return a number. It
works great on a few other controls on other forms, but in this case I get
the Overflow popup. The data being returned from the module is a number; I
have that field's data type defined as number.
 
After user changes updates the data in a date field/control on my form, it
calls WorkingDays2 in order to compare the two dates and return a number. It
works great on a few other controls on other forms, but in this case I get
the Overflow popup. The data being returned from the module is a number; I
have that field's data type defined as number.
Click to expand...

What's the FieldSize of the table column storing the value? A Number field can be an Integer, Long Integer, double,
Single, etc ... if your module is returning a Double, and your column is expecting an Integer, you'll get the overflow

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
The table column storing the data is Long Integer. The format for the
control is General Number with 0 decimal places.
 
Back
Top