CODEWITHSUNDEEP
ms-access
Bill Software Engineer
Bill Software Engineer

Reputation: 7792

MS Access Form Textbox not Editable

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?

Upvotes: 6

Views: 20334

Answers (3)

Markm0705
Markm0705

Reputation: 1440

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

Upvotes: 0

Robin
Robin

Reputation: 61

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

Upvotes: 2

steampowered
steampowered

Reputation: 12062

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

Upvotes: 5

Related Questions