Change font for each text box using VBA

[prairiewind via AccessMonster.com]

The front page of a report has fields that a user can change according to
their needs. Is there a way for the user to specify the font type and size
for each control individually? Possibly for just each section (a couple of
headers and the detail sections)?

I've tried:

With Me.GroupHeader0
Me.FontName = Me.TitleLineFontName
Me.FontSize = Me.TitleLineFontSize
End With

TitleLineFontName and TitleLineFontSize are fields in a table in which a
person specifies the font type and size.

Am I on the right track going that direction?

I'm using Access 2007.

Thanks,
Jeff

 

[Duane Hookom]

How do your records "in a table" know which controls to change? Your code
would need to reference specific controls rather than sections. You could
use DLookup() to find the appropriate property values.

Duane Hookom
MS Access MVP