really didn't see a forum to put vba tips... moderator, move wherever you feel is appropriate..


the locked property of textboxes i never really like or the enabled = false.

what i've done is to drag a label and completely cover the textbox [label that is included with a textbox (ms-access), too] and for the text of the label i embed a char 255 - [sort of like a space, but not].
You can embed it by holding down the Alt key and on the number pad typing 255.

A user will not be able edit or type into the box and it looks completely normal.