Just trying to add numberous fields in an access report footer. Can't accomplish this in textbox itself as the string for the addition is too long. Anyone have any ideas how I could accomplish this in VBA?
I tried the following on the OnOpen event of the report.
Private Sub Report_Open(Cancel As Integer)
Me.txtTotMfgExp = Me.txtUtilities + Me.txtProperty + Me.txtRent + Me.txtDepreciation + Me.txtPropTax + _
Me.txtMfgSup + Me.txtQualAudMan + Me.txtTools + Me.txtEquipRep + Me.txtVehExp + Me.txtBuildRepMtc + Me.txtTrainEduc + _
Me.txtContImpr + Me.txtEmplPreInj + Me.txtWasteDispTrsh + Me.txtCompExpSup + Me.txtSafeFirAid + Me.txtSecSys + _
Me.txtTelT1CdlsExp + Me.txtPostage + Me.txtFrghtDelry + Me.txtOffSupp + Me.txtCopPrint + Me.txtPayExp + _
Me.txtUniforms + Me.txtShopExp + Me.txtTrvlMls + Me.txtDuesSubs + Me.txtEmpRec + Me.txtSusp
When I run that though, I get the following error;
Run-time error '2427':
You entered an expression that has no value.
Thanks in advance for the help!