Menu
I have setup a textbox in a form in Access. The form is linked to a table. But the textbox it self is unbound, it is used to simply gather user input. However, I can't edit the value went it's viewed.
The textbox is not locked. The textbox can be set value in VBA. Textbox have no ControlSource. I can edit it in DesignView.
Any ideas?
949
Open the form in design mode and open the property sheet. For each control that you want to "disable", go to the Data Tab of the property sheet and set the Locked Property to Yes. The user will then be able to see the field but not edit it.
A quick way to create a bound text box is by dragging a field from the Field List pane onto your form or report. Access automatically creates a text box for fields of the following data types: Short Text. Long Text.
I think vba controls have two properties which can cause this. Locked and Enabled. Is the textbox enabled?
152
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
