Lock out a single field

[andrewhall]

I am running an application that uses Access as the backend database. One form in the app automatically enters a date in the Opened Date field (i.e. Start Date). That date should never be changed.

Unfortunately the form allows the field to be changed.

I do not have access to the code of the form to lock the field once it is populated. Some crazy thing about going out of business.

Is there a way to lock the field from Access directly? I can only find references to locking fields by using the form.

Thanks

 

[The_Doc_Man]

If you don't have a source for this app and the back end is the Access Jet database, I don't know of a way to do this.

 

[boblarson]

If it is entered automatically just change the Locked property of the text box on the form to YES in design view and it will be always locked.

 

[boblarson]

As Doc said, I missed part of this for some reason, you can't control whether the field gets updated or not unless you control it from a form.

 

[Jeanette Cunningham]

What is preventing you from being able to open the form in design view and set the field to locked?

 

[andrewhall]

I do not have access to the code of the form to lock the field once it is populated. Some crazy thing about going out of business.

 

[boblarson]

I do not have access to the code of the form to lock the field once it is populated. Some crazy thing about going out of business.

You don't need to have access to the code. But you do need design view access for changing the control. Otherwise there is NO WAY to do what you want to do - period. So you are stuck.

 

[andrewhall]

I was afraid so. Thank you for your help.

 

[gemma-the-husky]

try everything access .com

wayne will be able to unlock the app, if you can show you are entitiled to it.