Validate a Memo field

[Matt]

I am trying to validate the contents of a memo field on a form when a key is pressed, this only seems to work after the record is saved and then navigated back to. My sample is below, I want to ensure that there is something in the field before the record is updated.

If Me.Mymemo is "" The
MsgBox("You must enter a note"
End If

Is there something special that needs to be done with a memo field before it's contents can be checked, or is there another way of doing this

Thank
Matt

 

[tina]

i'm not sure where you're running your code from; i would use the form's
BeforeUpdate event, as

Private Sub Form_BeforeUpdate(Cancel As Integer)

If IsNull(Me!MemoFieldName) Or Me!MemoFieldName = "" Then
Cancel = True
Me!MemoFieldName.SetFocus
MsgBox "Please enter a value in the memo field."
End If

End Sub

hth

I am trying to validate the contents of a memo field on a form when a key

is pressed, this only seems to work after the record is saved and then
navigated back to. My sample is below, I want to ensure that there is
something in the field before the record is updated.

If Me.Mymemo is "" Then
MsgBox("You must enter a note")
End If

Is there something special that needs to be done with a memo field before

it's contents can be checked, or is there another way of doing this?