message box

  • Thread starter Thread starter rml
  • Start date Start date
R

rml

How do I make a message box popup on current if a text
field has data in it? If not, no message box. I have
the code working but it seems to pop even when it is
emtpy.

Thanks.
 
Try testing for the length of the text. Keep in mind, you didn't post your
code so I'm not sure how you are executing the process.

Here's an example:

If Len([MiddleName]) = 0 Then
Msgbox Prompt:="You did not supply a middle name."
End If

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Place the msgbox call in an If statement that checks the value of the
control. If that's what you're doing, please post the code so we can see
what's wrong. Are you sure the field has no data (null)? Have you allowed
zero length strings in this field?
 
Back
Top