To all who replied to my earlier post: thanks! A lot of intriguing ways to approach the task.
However, none of them work in this instance. I believe the difficulty is that the report is based on a crosstab query...so there's a textbox named 'FieldX', which is the same as the name of a field in my database...but the synonymous control source for 'FieldX' points back to the crosstab query, *not* the database. Since it is a derived value Access doesn't seem to want me to be able to multiply against that value.
If I use ExpressionBuilder and set the control source to
'=[FieldX] * 10', then the report will run and the column for FieldX will say 'Error' all the way down.
If in code I add to the Detail_Print Event something like 'Me.FieldX.Value' I get an error saying I can't do that unless the control has the focus; if I add a .SetFocus command before that, I get an error saying I can't use that method in the current view!
So...how in the heck can I manipulate a field resulting from a crosstab-query report??? Help!
However, none of them work in this instance. I believe the difficulty is that the report is based on a crosstab query...so there's a textbox named 'FieldX', which is the same as the name of a field in my database...but the synonymous control source for 'FieldX' points back to the crosstab query, *not* the database. Since it is a derived value Access doesn't seem to want me to be able to multiply against that value.
If I use ExpressionBuilder and set the control source to
'=[FieldX] * 10', then the report will run and the column for FieldX will say 'Error' all the way down.
If in code I add to the Detail_Print Event something like 'Me.FieldX.Value' I get an error saying I can't do that unless the control has the focus; if I add a .SetFocus command before that, I get an error saying I can't use that method in the current view!
So...how in the heck can I manipulate a field resulting from a crosstab-query report??? Help!
