data entry form format and null values

B

bbcrock

I inherited a project that is badly coded.

I have a form with elements that are added together. The elements
cannot be null, but if the user deletes one, the field becomes null and
all calculations stop. the current format on the form element is

0.0;(0.0);-

How can I modify these fields to default to zero when the user deletes
the values in the field?

thanks,

Don
 
K

Klatuu

The Format property does not control what is entered. It only applies to the
value displayed. One approach would be to use the Input Mask property.
Another (My Prefered) is to wrap each element in the calculation in the NZ
function:

Instead of:
Me.txt1 + Me.txt2 * Me.txt3
Use:
Nz(Me.txt1,0) + Nz(Me.txt2,0) * Nz(Me.txt3,0)
 
M

Marshall Barton

I inherited a project that is badly coded.

I have a form with elements that are added together. The elements
cannot be null, but if the user deletes one, the field becomes null and
all calculations stop. the current format on the form element is

0.0;(0.0);-

How can I modify these fields to default to zero when the user deletes
the values in the field?
Click to expand...



Use the Nz functio when you add the values.

=Nz(element1,0) + Nz(element2,0) + . . .
 
Top