I have 2 unbound text boxes in a Form. The short of it is, they're both locked (Text Box Properties: Locked = Yes), but the user still has the ability to type characters into the boxes. Why?
Setting them to Enabled = No doesn't allow them to type into the textboxes, but I want to be able to set the ForeColor of the text to red under certain circumstances (Me.txtMyBox.ForeColor = vbRed), and my research tells me you can't do that... that it's best to Lock them rather than Disable them.
Does anyone know how one can make it so that an unbound, calculated field can be "locked" or "disabled," and be able to set the ForeColor in my Load event?