Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Finland
    Posts
    80

    Unanswered: Form: Check empty fields

    Does anyone have fuction or sub that could check all the fields for empty values in a form after user presses a button? I made a crude piece of code to check the fields, and although it works it looks ridiculous

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Lightbulb Your code

    Please post it so we can see how you have approached this
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Oct 2003
    Location
    Finland
    Posts
    80
    Ok, here goes...

    Dim check1 As String
    Dim check2 As String
    Dim check3 As String

    check1 = IsNull(Etunimi_popup)
    check2 = IsNull(Sukunimi_popup)
    check3 = IsNull(Koulutusohjelma_popup)

    If (check1 = True) Then
    Etunimi_popup.Value = "*"
    End If

    If (check2 = True) Then
    Sukunimi_popup.Value = "*"
    End If

    If (check3 = True) Then
    Koulutusohjelma_popup.Value = "*"
    End If

Posting Permissions

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