Empty text box

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Need a little help. I have a text box on a report I’ve formatted from the
Format property to #,###. My issue is when the text box is 0, it displays
nothing.
Thanks,
Mark
 
Some further clarification:
Control Source = DCount("*","qLetter Count","[Letter#] = '03' ")
Format = #,###

With a msg box in the On Format of Detail, it shows this field equals 0.
 
Try a format of #,##0



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top