Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    system messages (2000)

    When forced fields are not completed, a standard system message is generated informing the user that a field needs completion. The message is not very instructive in simple English terms. Is there a way to override this with a more usuer firendly message by incorporating the msgbox function?

    Thanks Darren.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: system messages (2000)

    You can do this in a form (not in a table or query). Use the Before Update event of the form to check whether all required fields have been filled in. If not, set the focus to the appropriate control, issue a message, set Cancel = True and exit the event procedure:

    Private Sub Form_BeforeUpdate()
    If IsNull(Me.ThisControl) Then
    Me.ThisControl.SetFocus
    MsgBox "Please fill in ThisControl", vbExclamation
    Cancel = True
    Exit Sub
    End If

    If IsNull(Me.OtherControl) Then
    Me.OtherControl.SetFocus
    MsgBox "Please fill in OtherControl", vbExclamation
    Cancel = True
    Exit Sub
    End If

    ...
    End Sub

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: system messages (2000)

    Thanks Hans

    Darren.

Posting Permissions

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