Hi,
   i have made a report in access 2000.It contains some calculated numeric fields having default value 0.If somebody enters no data on that particular field it shows that particular field having 0 value.how can i hide the field contain 0 from the report Preview and also from the printing.

with exemple pls.?

This method assumes you have executed a query, the results are in the recordSet named rs and the field you talk about is the first element in the record set:

IF rs(0) > 0 then
   response.write rs(0)
ELSE
   'do nothing
END IF

Wind is your friend
Matt