Grey out textboxes

C

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
 
M

Marshall Barton

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


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