The problem: When we use formulas on textboxes in the report footers of MS Access…