Empty text box

[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

 

[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.

 

[Mark]

OK just set the format property tp Standard.......

 

[John Spencer]

Try a format of #,##0



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