MS Access 2007-13 Text Box - Cannot Edit

Question

Hello!  I have an Access Database which works fantastic when in the "new record" entry.  The problem is when a user goes into the record after entry it will NOT allow them to edit text fields.  It will only allow "cut and paste".

Any suggestions?

Answer 1

Could you post the SQL view of the recordsource of the form and the subform? Do you have any macros or VBA code on the form? Is the database split (shared backend with tables, individual frontends with everything else)? If not - SPLIT IT RIGHT AWAY, that's a likely cause of the problem and of many other problems!

I cannot imagine what setting would allow data to be entered into a form with cut and paste but forbid typing... that's weird. Might it be possible to upload a trimmed-down (no confidential data) copy to a Dropbox or other file sharing site?

Answer 2

Interfacing from a form (and subforms) linked to a query or table.

Answer 3

I figured you would need more info.. Yes all users are working off of a form, with subforms (and yes i have checked all allow edits).  When they are entering the "New Record" they can freely enter text in the fields with NO problem... Only when the "re-enter" the record again to make updates or whatever...is the record seemingly locked... They CAN cut and paste information into the form, by cutting out of another program (say MS Word) and pasting into the field.  Also what i mean by 2007-13 is that it is happening in all versions (also 2003 if that matters).  Thanks again in advance for the assistance!!

Answer 4

Need a lot more info. What do you mean by "2007-13 Text box"? Are you working from a form? Does the form have AllowEdits sent to No?

Answer 5

How are you interfacing with the records - directly in the table, via a query, form?