Hiding a 0 value in a SubForm

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I bring up the main form the SubForm displays all the records associated
with the main form. The SubForm displays all the records and "0". Is there a
way to get rid of the 0 from displaying in the subform?
 
Format the control in the subform where you want to supress the 0:
"#,###"
 
Do you mean format the control source in the field of the subform? I tried
that and didn't get it right if that's what I was suppose to do. Could you
please give me more detail please?
 
In the Format property of the control. It is the first box in the Format tab.
 
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

referring to Subform Total in main form 1
Multiple subforms 0
subform total behaving strangely 2
Main Control References SubForm Control 2
Duplicate record in Form and Subform 0
'No Current Record' error from subform on Close 1
Access 2007 Attachments 1
Access Main form/Subform Navigation 0

Back
Top