First, please don't type in capital letters. In newsgroups it's considered
"shouting."
Q1. Check out Validation Rule and Validation Text in Help. It will explain
how to enter a criteria for any data you enter, and if the criteria is not
met (in your case >0) and how to post a message to the user that the entry
is invalid. Very easy to use...
Q2. All non-whole numbers (Single or Double) are stored with as many places
as the value requires. That's the way it is with all databases. As the
designer you are always allowed to control how that number is displayed to
the user, and how that number is used in subsequent calculations... which is
really all that is necessary.
Say you have a stored number (ex. name = XValue) and it is equal to .0031675
and you want to use just the .003 portion in a calculation... like XValue *
3, and want/would expect a result of .009.
Val(Format(XValue,"#.000") * 3 = .009
XValue * 3 = .0095025
Numbers store exactly as they are... use your Access tools to control
display and value... from there.
hth
Al Camp
