Allen, thanks for your reply. You have a great website by the way. I've used
it a lot. I have tried to set the format through the properties sheet, but
there are no options in the format line for this field either in the form or
the query (I lose those options as soon as I make it a DSum expression)

What I'm trying to do is display a value that represents how full a
particular bin location is. I want to display it on the same form (a
continuous form) that is used to add new bin locations. I have a query
(qryFillPercent) that performs all the calculations I need, but I can't base
my form directly on this query because I lose the ability to add new records
since it is not a simple select query. I tried using a DSum function as the
control source of an unbound text box on my form, which worked fine except
that it displays #Error in the last line of the form (the new record line).
Someone else in this forum suggested that I add the DSum to a simple query,
then base my form on that query and use the query field as the control source
of the text box. That solved my #Error problem, but now I have my format
problem.

If all this makes any sense, maybe you or someone else has some other ideas
on how I could approach this. Maybe I'm going about it the wrong way.

Thanks for your help.