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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Field name derived from a string value returns a Run-time error 2465. 2
Quick Access Tool Bar 1
Programmatically make a label permanently visible 4
Drag n drop not creating labels for the fields from the field list 3
Changing type of line in a form 1
Drag fields onto without labels or labels on top of field? 3
remove paperclip icon and add a caption in a datasheet 5
Multiple Table values visible in controll box 2

Back
Top