Inputting Data in a Form

[Lou_Reed]

I inherited an MS Access 2010 db Project from another analyst. It seems that there is some trouble in inputting values in a box on some forms. The box is there, certainly, but
any attempt to input data is not possible, even the cursor will not go into the far upper left region of the box. Everything is just frozen out and any attempt to input values is
hopeless. In a situation like this I usually check the properties of the box in design view.

What property may be causing this and I guess by changing it, that would make the box on the form capable of input.

Any help appreciated. Thanks in advance.



Respectfully,

Lou Reed

[ranman256]

check the form properties:
locked = false
allow edits = true
recordset = dynaset

check the textbox props:
locked = false

see if the event that opened the form did not open it as readonly

[Lou_Reed]

I will give it a try. Thanks.

Respectfully,

Lou Reed

[Lou_Reed]

What us the difference between form
locked = false

textbox
locked = false

It seems that the form locked could cover the textbox. In other words lock the form and you lock the testbox meaning the latter is not needed.

What is the difference?


Any help appreciated. Thanks in advance

Respectfully,


Lou Reed

[Lou_Reed]

Okay, when I change locked input control from no to yes, the data entry box is still not editable, but the background changes from white (clear?) to gray? I am not sure what is going on here.

Please advise.

Thanks in advance.

Respectfully,

Lou Reed

[andy49]

Does the form have a query for its recordset? Is this an editable query?


Sent from my iPhone using Tapatalk

[Bulzie]

You have Locked and Enabled properties:

Locked = Yes (means you cannot enter/edit data to that field.)
Enabled = Yes (allows you to put the cursor into that field to do a right click for example but you still cannot change data if Locked = Yes.)

So if you don't want them to get into that field at all and want to keep field color white, Locked = Yes and Enabled = No

[Lou_Reed]

This form I does not have a query for its recordset.

gain, what does it mean when the form input area is gray?

Respectfully,

Lou Reed

[Lou_Reed]

Ok. I think that I know why the entry box on a form is gray. It means that enabled is No and locked is No. In other words it is unlocked, but not enabled. That seems to be a contradiction. But it is true, is it not?

I guess that one must be harmony with other or a gray box appears.

Is this correct?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed