In a report, for every record, I would like a checkbox to appear checked if a certain field contains any value.
The field is Client_comments. (memo field)
I added a checkbox called CkComments and added the following vba to the report code.
Expand|Select|Wrap|Line Numbers
- Private Sub CkComments_Load()
- If IsNull(Client_comments) = False Then
- CkComments = True
- Else CkComments = False
- End If
- End Sub
I'm not sure if this is the right way to accomplish what I am looking for so any help is much appreciated. Thank you!
martin