Text field in form is returning only a particular value

[safeerbinsalih]

I have a table ("Instrument_master") which have a long integer field called Calibration_frequency. I made a data entry form using form wizard for this table. But whatever value I enter in the field Calibration_frequency, it is returning only a specific value (in this case 90) to the table. There is no default value set to this field. If I go and edit in table it is changing. But form is returning only this particular value to table. Any ideas?

 

[ypma]

Just guessing. Are you entering whole number or numbers with decimal places? , Have you checked the format property of the field within the form you are using? When you enter whole numbers give example of what’s saved in the table.


Regards Ypma

 

[safeerbinsalih]

I'm entering whole numbers only. Format property was blank. I've changed to General number. I will try now.

 

[arnelgp]

use datasheet view or continuous form view (wild guess).