changing labels on a report using VBA.

[LOUISBUHAGIAR54]

Hello all ye experts.

Can you please tell me whether one can use VBA to change a label on a report ?
I intend to use text and a variable to insert in the label.

Many thanks.

LouisB

 

[pbaldy]

Sure, in the Open event. Commonly done with crosstab queries having dynamic field names.