MS Access Form Textbox not Editable

5
votes

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?

3
ms-access
Ah, you are aboslutely right, that fixed it. - Bill Software Engineer
@JeffO Yea, if you submit it as the answer, I will accept it. - Bill Software Engineer
Just ran into the same thing - I had set the form to not be editable. Thanks! - FreeMan
Also, make sure the Form Property "Allow Edits" is set to "Yes" - Elron
Thanks bud for helping me out on this decade old question - Bill Software Engineer

3 Answers

5
votes

I think vba controls have two properties which can cause this. Locked and Enabled. Is the textbox enabled?

2
votes

Another possible cause of this issue (to help others in my situation): If you are opening your form using VBA and the DoCmd.OpenForm method, make sure your 5th parameter is not "acFormReadOnly"!

Not editable text boxes:

DoCmd.OpenForm stFormName, , , , acFormReadOnly, acWindowNormal, stLinkCriteria

Editable text boxes:

DoCmd.OpenForm stFormName, , , , acFormPropertySettings, acWindowNormal, stLinkCriteria

0
votes

I had this problem when looking at the Form in 'Layout view'. When in 'Form View' of 'Datasheet View' the text box can be edited