[RESOLVED] [RESOLVED} Need VBA code to set field's enabled property to "false"

[carbo]

I need vba code that will set the enabled property of a field named "Remarks" to "false" if data is present and leave it "true" if it has no data. This is an Access 2000 database (Flat file).

Thanks

Carbo

Solution:

Private Sub Form_Current()
If IsNull(Remarks) Then
Remarks.Enabled = True
Else
Remarks.Enabled = False



End If


End Sub

[qwertypunk]

can u be a more explicit ......more precise please

[carbo]

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

[Hack]

Access VBA question moved to Office Development

[carbo]

Private Sub Form_Current()
If IsNull(Remarks) Then
Remarks.Enabled = True
Else
Remarks.Enabled = False



End If


End Sub