Didn't get noticed from Feb 7th

  • Thread starter Thread starter DaveB
  • Start date Start date
D

DaveB

My original question starts at the >>

-----Original Message-----


Could you describe what steps you took to "add a negative number", and
the actual error message? prehapse with the Control Source or the code
which calculates the price?


.
Click to expand...
Sure thing. I simply added a minus sign before the number.
I found out that I would have to change 2 fields. I took
the Form directly from the Northwind Sample data base,
it's the Orders Form. The error message really isn't an
error message, it's just a message that says, "You must
enter a positive number. When I click on help it says
<Table-level validation text> (Error 3316)
My text is in dollar amounts which I would prefer to keep
that way. I just wish that I could make it accept
negative numbers also.
 
Open the Order Details table in design view and click on the Unit Price
field. Notice that in the properties for that field there is a Validation
Rule requiring that the entry be greater than or equal to 0. Delete the
rule and the validation text and you should be able to enter a credit
amount.

hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
 
Back
Top