I need to change the decimal value in one of my databases. Currently my company uses an ID system with nice whole numbers, i.e. no decimal numbers. Now my boss has this grand scheme to start using decimals. 1.17.1 etc. I can't seem to be able to get my table and form to accept the change??? In my table I currently changed the "Decimal Places" to 2 and the "Format" to "General Number". I then tell it to update format everywhere the ID is used. I have gone into my form based on this table and set the specific field to allow decimal places as well. It won't work. When I enter a number directly into my table, 2.1, the field reverts to 2. ????? What am I doing wrong here? and... is it possible to set the format to allow numbers such as 1.12.4 but not allow any letters?
Thanks for any Help
Thanks for any Help
Comment