Others

Fix #Size! Errors in Microsoft Access Subform Totals

Huda QurayshiHuda Qurayshi Nov 20, 2026 869 views

Question details

The user needs to display a subform total on a Microsoft Access main form without a #Size! error.

Fix #Size! Errors in Microsoft Access Subform Totals
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.
Before you start

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.

Solution 1Recommended

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.

1
Check the footer calculation

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.

2
Verify the total in the subform

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.

3
Find the subform control name

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.

4
Correct the main form expression

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.

5
Test the result

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.

Check the subform total and main form reference
Name and source object can differ: For example, the subform control may be named Subform-Translations while its Source Object is Subform-Translation Allocations. The main form expression must use the control name.
Free Microsoft Office alternative

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.

Calculate totals from exported Access data in spreadsheetsOpen and edit Microsoft Excel XLSX filesUse a familiar interface for an easier transition from OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

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.