Please help with a stuck field

N

NY4RR

Hello,

I've been using Access for years at work to keep track of donor records
and suddenly, we can no longer enter data into a particular field. I
can see the text I want to change, but into the box as I normally would
does nothing. I've clicked around for shared properties, etc., but had
trouble locating them. We have a couple of people using this program
around the office but we never make major (or even minor) changes to
the design. I'm wondering if something got locked accidentally but
cannot figure out how to address it.

Any ideas much appreciated.

Thank you!
 
R

Ruel Cespedes via AccessMonster.com

Is it possible that someone Disabled and Locked the Field? Get everyone out
of the .mdb file and open the form in design view. Right mouse click the
field in question and look at its properties. Within the properties window
goto the Data Tab. There you will find the fields data properties. Look for
Enabled to be "Yes" and Locked to be "No". If NOT then correct them to those
settings.
 
N

NY4RR

I haven't quite been able to fix it yet, but thank you for your
suggestions. I tried "compact and repair," which is probably helpful
anyway. I also checked the settings and it appears that "enable" and
"locked" are correct. Yes it is info entered through a form, so I
tried looking in "table mode" but the data we're having trouble with
doesn't seem to be accessible through that. Perhaps there's a hidden
secondary table.

It does still feel like something is unnecessarily locked since the
data entered in that portion of the form used to be edited easily but
is now unresponsive. Also, we can no longer add to it when in the past
we had blank lines.

If anyone has any other insights, please feel free to share.

Best,
S
 
N

NY4RR

P.S. Looks like it can be edited in the "table" version, just not
through the "form." Thanks for your help in narrowing it down. Hope
to get it fixed soon. Any other ideas welcome as well.
 
Top