Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    287

    Unanswered: Null or Blank Date Check?

    Hi all,

    Wondered if anyone can help me with my problem with a date field?!

    I have a form with a couple of ONCLICK events on a few of the fields, but I want to make it so it first checks the date field has been filled in (eg: is not null) - I know the rest of the code using IF.. statements
    but what VB code do I use in the IF statemnent to check if [cboDate] is not been inputted or blank!! (I have tried IS NUll, =0, ="", etc etc nothing works)

    Please help!!

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    if isnull([cboDate])=true

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    or even IsDate() since you are validating a date entry. It will check for nulls and if the entry is a date too.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Watch out for blank strings too....

    if nz([cboDate], "") = "" Then...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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