Empty text box

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
 
M

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

John Spencer

Try a format of #,##0



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