Stopping user from changing text

[Guest]

I have a label on a report header where i want to stop the user from changing
the text but i want the user to be able to change the font, size and colour.
Is this possible with abit of VBA code

 

[Marshall Barton]

I have a label on a report header where i want to stop the user from changing
the text but i want the user to be able to change the font, size and colour.
Is this possible with abit of VBA code

Probably possible by setting the label's properties in the
report's Open event procedure. E.g.

Me.thelabel.FontName = "Arial"
Me.thelabel.FontSize = 12
Me.thelabel.ForeColor = RGB(255,193.192) 'Pink

But if the user can specify the values of the properties,
you will need a mechanism for them to enter the desired
values. You will then need to retrieve the property
settings and use those values in place of the constants I
used in the above example.