Hi
How can I loop rows within a report to catch all the rows through VBA code. I want to assign the rows to a single string variable.
I've tried this but it doesn't work.
For Each varItem In Me.Report
strBodyText = strBodyText & Me.Report.ItemData(varItem)
Next varItem
Is it possible to loop within a report to catch all the data and assign to a string variable?
Thanks
How can I loop rows within a report to catch all the rows through VBA code. I want to assign the rows to a single string variable.
I've tried this but it doesn't work.
For Each varItem In Me.Report
strBodyText = strBodyText & Me.Report.ItemData(varItem)
Next varItem
Is it possible to loop within a report to catch all the data and assign to a string variable?
Thanks