This particular database, because of the nature of it mission, is designed to allow users to scroll back to previous records and make additional entries, Not all records however have data in the remarks field and current conditions require the records with data in the remarks field to be enabled=false to avoid corruption problems that sometime occur in memo type fields in a multi user environment in msaccess. So I have programmed a button with a code “Remarks. Enabled=True” that the user uses if the field need to be edited. I have tried the following code but it ignores records with data.

Private Sub Form_Current()
If Remarks.Value = Not Null Then
Remarks.Enabled = False

End If
End Sub