Unable to lock non-string fields on a form

[Guest]

Hi, I was wondering if anyone could help. I have a strange problem on one of
the forms I have created. In the design view of the form, I selected all
fields and set them to be locked, then when the form opens, the first field
is unlocked and then the _AfterUpdate for that field unlocks the next, and so
on.

Now when the form opens, my first field is unlocked as required, however if
I then try and enter any data in a field defined as a string, I cant (this is
as it should be), my problem is, any fields setup for integers can have data
enetered even though they are locked.

If I manually put code in the Form_Current to Lock and unlock fields I get
the same problem - strings act as they should, but integers never lock.

Any help would be greatly appreciated

 

[Arvin Meyer [MVP]]

That shouldn't happen. Try also enabling and disabling the controls:

Me.txtControlName.Enabled = False
Me.txtControlName.Locked = True
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

Hi Arvin,

Thanks for the quick reply, I have tired using the code you mentioned and I
have the same problem, fields for strings lock as they should, but fields for
integers dont. Any other ideas?

 

[Guest]

Hi Arvin,

I have solved the problem, it was user error (mine) I should have checked
my code more closly.

Sorry.