Change font size in a report field based on drop down

[tedmillerx]

I want to offer the user the ability to change font size in a number of report fields based on the font size selected in a form drop down menu.

For instance, when the user selects "Large font", it will convert all fonts in a report to 14 point. "Regular font" makes it 12 points. "Small font" makes it 10 points.

Obviously, I could just make three reports, but it's clumsy and I've got 120 reports to do this to (I don't want to build 360 total reports!)

Can someone suggest the code I would use for the report fields to make the font dynamic? I've looked around here and Access Other and can't find anything.

Thanks!

 

[PWise]

on reportopen

me.controlname.fontsize = forms!formname!controlname

make combox 2 columns

columns width 0";3"

 

[tedmillerx]

thanks for the help! I'll give it a try.