Grey out textboxes

[Chad]

I have 12 continuous forms across a form to represent the 12 periods of the
year. I have code written that disables and locks subforms that are
populated with actuals (prior months). I would like to remove the border
from the textboxes where actuals are present. I know I have to do this with
code, but I cannot find anything that references changing the border color of
the textbox on a continuous subform.

Thanks

 

[Marshall Barton]

I have 12 continuous forms across a form to represent the 12 periods of the
year. I have code written that disables and locks subforms that are
populated with actuals (prior months). I would like to remove the border
from the textboxes where actuals are present. I know I have to do this with
code, but I cannot find anything that references changing the border color of
the textbox on a continuous subform.

If you want to remove the borders, try setting the
BorderStyle property to 0.

Check VBA Help for that as well as the BorderColor and
SpecialEffect properties.