Stopping user from changing text

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
StuJol said:
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
Click to expand...


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.
 
Back
Top