Long Text Box

[data808]

Why does this code not work on a "Long Text" or "Memo" box? It works fine in a "Short Text" box.


If IsNull(Me.txtResolution) Then
MsgBox "Resolution Field Must Contain Information.", vbInformation, "Requirements"
MsgBox "Your Record Was Not Saved.", vbInformation, "Notification"
DoCmd.RunCommand acCmdUndo
Exit Sub
End If



Right now it just skips over this code. Can anyone help with this?

[ranman256]

It IS possible that txtResolution = "".
Check for that too.

[June7]

If Me.txtResolution & "" = "" Then

[data808]

I'll try that but does anyone know why I would have to change the code just because the text box is a slightly different format?

[June7]

No idea why your field/textbox acting that way. I just tested a textbox bound to memo type field and the IsNull check works.

[data808]

yeah i have no idea either. but i do know that the long text is the cause because when i change the format of the text box to short, the code then works. weird. i still haven't tried the:

if me.txtresolution = "" then

once i try it i will let you guys know if that works.

thanks for the help.