Simple one!

  • Thread starter Thread starter su
  • Start date Start date
S

su

Hi
I am bit new to Access and have been creating a database
which has a form with two fields. I am then using a Label
to add these two fields on the form. This works fine. The
only problem is that the two fields (number data type), in
them the default value is 0 but the the label shows an
error message. As soon as the fields are updated on the
form the label shows the right answer. Is there a way I
can avoid seeing that error message. I have tried to
change the label property default as 0 but it does not
work.
Help please.
Many Thanks
 
Hi Su,
Perhaps an IIf statement to format the field when
there is no value in it. Something like the following.

IIf(IsNull(Me.MyField), 0, Sum
(Me.MyField.Value))

Substitute your field name for the one in this example.

Hope This Helps
 
Back
Top