Hi,
I have a field Completion in a access form.
How can i do that when Completion field contains value or even after input then it should be read-only.
and in which property to add the condition.
Novice
Windows 10 
Access 2016
Hi,
I have a field Completion in a access form.
How can i do that when Completion field contains value or even after input then it should be read-only.
and in which property to add the condition.
Access Developer
Windows 7 32bit Access 2016
Perhaps something like:
Put code in the Forms On Current event and the controls After Update eventCode:Me.YourField.Locked = IsNull(Me.YourField)
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Access Developer
Windows 7 32bit Access 2016
Sorry. Code should be:
Code:Me.YourField.Locked =Not IsNull(Me.YourField)
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Read only field on Split form
Read and update a field in another table.
Posting Permissions
Reply With Quote