I know you said you checked for a default value, but did you check "format mask"? Sounds like an old 6.5 format mask that prevented alpha from being entered into a numeric field.
Karen In a message dated 3/22/2012 7:29:48 AM Central Daylight Time, [email protected] writes: > I converted a entry form from 6.5++ to 9.1 (Build 9.1.5.20317) > The form has a series of fields: end1, end2 (ending readings) where we > enter the mileage used for a piece of equipment. > This is not an external form. > > When you tab to one of the ending reading fields it is empty. > But the problem occurs when you type the first numeric character. > A zero pops up in the low order position creating a 2 digit number ending > in zero. > If you type a 5 you get 50, type a 3 you get 30 etc. > The user then has to delete the unwanted zero(s). > > The form field has no "Default Value" in the "DB Edit Properties" under > "Effects tab". > > The ending reading columns (end1, end2) are defined in the table as REAL. > There is a Rule on the column end1: (rda3.end1 IS NULL) OR (rda3.end1 GE > rda3.begeqp). > This is to ensure that if a reading is entered, it is greater than the > beginning reading. > > In the old 6.5 system the ending reading could be entered without the low > order zero popping up. > Any suggestions?
