I am looking to populate a report textbox using a value contained ina variable of code. The only way I have found to do anything close to this is using a label. Since, I need to use the value within the report to calculate other report values, I would prefer to use a textbox.
Here is the code I have to populate labels. Anyone who can help me do this with textboxes, it is appreciated.
DoCmd.OpenReport strReportName, acViewDesign ' open report in design view
With Reports!rptRORRatio
.lblIncentivePaidLookup.Caption = lblPaidFeesAccumulator ' populate fields
.lblFundsAvgNALookup.Caption = dblFundsAvgNA
.lblLPsAvgNALookup.Caption = dblLPsAvgNA
.lblDate.Caption = strEndDate
End With
Thanks,
Jason
Here is the code I have to populate labels. Anyone who can help me do this with textboxes, it is appreciated.
DoCmd.OpenReport strReportName, acViewDesign ' open report in design view
With Reports!rptRORRatio
.lblIncentivePaidLookup.Caption = lblPaidFeesAccumulator ' populate fields
.lblFundsAvgNALookup.Caption = dblFundsAvgNA
.lblLPsAvgNALookup.Caption = dblLPsAvgNA
.lblDate.Caption = strEndDate
End With
Thanks,
Jason