Sub-form shows #Error for no data - how can I hide this?

[M Skabialka]

I have a continuous sub-form where one of the controls contains a DSUM of
some data pulled from another table based on current record data. It can't
be edited. However the user can add a new record on this sub-form but this
field shows #Error because there are no matching records in the other table
to sum. I have tried various conditional formatting conditions such as if
it is null, or less than 0.1 so that I could change the text to white, or
make the control invisible but nothing works. The#Error looks as though
there is an error which there isn't. Even On current events don't trigger
if null or blank or <0.1 to change the ForeColor.
What else can I do to hide this for any case where there is nothing to DSUM
yet?
Mich

 

[M Skabialka]

Thank-you Allen Brown for the code, and Jeanette for knowing where to look!
It works great.
Mich