Recent content by lisalehan

In the table that I think I need to be in to change it so it works throughout the different functions I cannot. it says that "the property cannot be modified in linked tables". I have changed it on other tables so that the data type is number and the field size is single...but it is still not...

I am looking under the format tab at format..my format was currency but I changed it to general. where should I be looking for the data type? if I look under the data tab the only options I have are: control source, input mask, default value, validation rule, validation text, enabled, locked...

I changed them from Currency to General Number and still only 4 decimal places with the numbers I put and the other 3 default to 0!! I am at a loss!!

Paul-the funny thing is that In the tables one of the fields was able to display the exact number that I put in. As for the other fields that I need to display 7they only displayed 4 of the decimal places that I put and the other 3 default to 0 after I click out of the field. For the one that...

it says the field size is double. thanks so much!!

it is a program that uses Access. When I asked support at ERP they said to use the help option in access!!!

I am using an inventory software program called ERP. I am trying to have at least 8 decimal places show in all my reports/tables/etc. I have set decimal places to 8 and 8 are showing up in some the reports BUT after the 4th decimal place, the other 4 decimals default to 0 (i.e. I put .19214...