Access 2000

[Marita_l]

I have an inventory control system I am trying to get into place. I am filling my tables with sample data for testing and form creating.

My problem has arose when I tried to put a small number into a field: .1667 It appears that the field is rounding down to zero. I don't want it to round at all. I can not seem to find how to turn it off. If anyine can help me solve this very frustrating problem I would be very relieved.

Thanks in Advance!

[Dr_Evil]

Make sure you are using an Access Data type that supports decimals. Setting the Format field to an Integer will not work but using Single or Double will work.
If this doesn't help reply with project details(ie, what controls you are using on form) & I will see what I can do.

[Edited by Dr_Evil on 05-17-2000 at 12:48 PM]

[Marita_l]

Dr. Evil,

Thank you for replying. I found they problem. I had to set the scale to the number of decimal places I wanted. Just setting the number of decimal places wasn't enough. Which is silly, If it was going to round to the nearest whole number you would'nt need any decimal places.

i was about to go crazy when I decided to put something in the scales propertie field.

Thank you fro your help.

Marita