Have a form I use for stats in the office. This is a monthly report with calculated fields in several subforms. When a calculated field is zero a blank area appears on the form. Would like to show a "0" instead. Used the usual format in properties to show the number or 0 but it still comes up blank.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
printing blank field
- Thread starter gary515
- Start date
when a calculated field is "=0", it should return a value of "0" if not, is you may have blanks in the field that it is calculating from, which would then give the Null return.<br>all fields involved in the operation must have a value in them in order to return a value for the answer. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
- Status
