How do I Display Negative Values as Zero (0)

[Hmu Hein]

I'm creating a form for a library system and in my form i would like to show the over due days of a borrowed book. I calculate that from the following equation:-
overdue days = return date - due date
(correct me if i am wrong)
and i get negative numbers for books that are not over due.
How to change that negative values to zero?

[TheSmileyCoder]

This is based on Ac2003, but I feel fairly confident it should work in Ac2007 as well.

You can specify the number format to use for the textbox. Select your textbox and in the property sheet find the format property and type in the following:
#;\0;\0;\0
You can see there are 4 semicolon-seperated values. The order specifees the format for:
Positive Numbers: # display the number
Negative numbers: Display a 0
0 : Display a 0
Null: Display a 0

I think that should work fine for you.

[NeoPa]

Smiley's suggestion is a clever one, and will work as long as you don't need to store the value shown.

It will show you what you want to see, but it won't change the actual data in the control. That means the value will still be negative, even though all that shows is the zero (0).