Fix #Size! Errors in Microsoft Access Subform Totals
Question details
The user needs to display a subform total on a Microsoft Access main form without a #Size! error.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A main form control references an aggregate total calculated in a subform footer.
- Observed behavior
- The main form displays #Size! instead of the expected subform total.
Open the main form and subform in Access, and identify the footer control that calculates the total. You will need to inspect the properties of both the subform control on the main form and the total control in the subform.
Check the subform total and main form reference
Use this method to verify that the total is valid and that the main form references the correct subform control.
Open the subform in Design View, select the total control in the Form Footer, and check its Control Source in the Property Sheet. For example, use =Sum([T-Estimate]) to total a numeric field named T-Estimate.
Switch the subform to Form View and confirm that the footer control displays the expected numeric result. If it does not, check the field name and data type in the subform's record source.
Open the main form in Design View, select the subform control, and check its Name property in the Property Sheet. Use this name in the reference, not the Source Object property.
Select the main form control that should display the total and set its Control Source to a reference such as =[Subform-Translations].Form![Total T-Estimate]. Replace both names with the actual subform control and footer total control names.
Save the forms and open the main form in Form View. Confirm that the total appears and changes as expected when the subform data changes.

Rebuild the form and subform controls
Try rebuilding the controls if the footer total works and all references appear correct but the error persists.
Work with exported Access data in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility. Export Access data to Excel format to work with it in WPS Spreadsheets; WPS does not run Access forms or fix Access subform errors.

Frequently Asked Questions
Which subform name should I use in the expression?
Use the Name property of the subform control on the main form, not its Source Object. Select the control in Design View and inspect the Property Sheet.
How can I check whether the subform total works?
Open the subform in Form View and inspect the total in its footer. If it is not correct, open Design View and check the total control's Control Source and the underlying field.
What does the main form reference look like?
Set the main form text box's Control Source to a pattern such as =[Subform-Translations].Form![Total T-Estimate], using your actual subform control and total control names.
Can WPS Office fix an Access subform error?
No. The reference must be corrected in Microsoft Access. You can export data to an XLSX file and use WPS Spreadsheets to calculate totals separately, but it does not run Access forms.




