Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Unanswered: MsgBox Based on Text Box Value

    I need to know how to display a message whenever the value of a bounded Text Box (Enabled = No) on a form is ZERO when navigating. Thanks.

  2. #2
    Join Date
    Apr 2003


    You need to use a Null value

    try something like

    If txtBox1 = Null Then

    Function ErrorMessageBox()

    Call SaveAssistantSettings

    With Assistant
    .On = True
    .Visible = True
    .Animation = msoAnimationGestureLeft
    With .NewBalloon
    .Heading = "Need Imput!"
    .Icon = msoIconAlertWarning
    .Text = "At a minium, you need to complete values for line one."
    .Button = msoButtonSetOK
    If .Show = msoBalloonButtonCancel Then
    MsgBox "Sorry, you need to complete at least one line!", _
    vbExclamation, "Null Value!"
    End If
    End With
    End With

    Call RestoreAssistantSettings

    End Function

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts