Therefore one bad expression can cause other calculated controls to display #Error, even if those controls are bound to valid expressions.įor details of how to do this with subreports, see Bring the total from a subreport onto a main report. When Access discovers one calculated control that it cannot resolve, it gives up on calculating the others. If you have many calculated controls, you need to do this on each one. Use the HasData property property, specifically for this purpose.
The workaround may not display the zero, but it should suppress the #Error.
' Return False for unbound forms, and forms with no records. 'Purpose: Return True if the form has any records (other than new one). If your computer does not have Microsoft Access, you can download a set of files which allow you to use the Microsoft Access to operate our Anaesthetic. Public Function FormHasData(frm As Form) As Boolean