Access 2007 Indicate When a Textbox Continues
How are you interfacing with the records - directly in the table, via a query, form?
Build a little, test a little
Was this reply helpful?
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?
Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Microsoft Access MVP since 2007
Was this reply helpful?
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!!
Was this reply helpful?
Interfacing from a form (and subforms) linked to a query or table.
Was this reply helpful?
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?
John W. Vinson/MVP
Was this reply helpful?
I don't think i can post the code... Yes the database is split, however the problem still exists.. one more wrench to the problem is that when I am logged on to the database (administrator) the problem goes away...
Was this reply helpful?
Well, without knowing anything about the form or its recordsource it's just groping in the dark to come up with any sort of answer. Unless you can post some more information about the database I don't see how I or anyone else can help! You may need to find some private support, local or over the web, to look at the database directly.
John W. Vinson/MVP
Was this reply helpful?
diedrichdoese1976.blogspot.com
Source: https://answers.microsoft.com/en-us/msoffice/forum/all/ms-access-2007-13-text-box-cannot-edit/d2516631-daab-4ec8-a09d-41011168e1cb
0 Response to "Access 2007 Indicate When a Textbox Continues"
Post a Comment