I have built some reports in MS Access. Yet, the user find that it is not that good to display #Error in the fields when no records return for the report. They would like to show a line of like "no records found" ... etc to override the line of #Error. It is nearly impossible for me to built another report when detected no record through modules as there are over hundreds of reports showing #Error when no records found. Please help urgently. Thanks.