Karen - I just double-checked under "DB Edit Properties" window "Effects" tab and both Format Mask and Default Value are empty.
Thank you for your response. Dayle Coxen Florida DOT (850) 410-5635 From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, March 22, 2012 9:10 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Zero pops up during Form field entry 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?
