Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2009
    Posts
    95

    Unanswered: Make Criteria of ComboBox NonBlanks

    I currently have a combobox that contains blank options, these records need to remain in the table but I want to cut them out of the combobox I have on a form.

    Does anybody know how I can set the criteria in the row source of my combo box to only contain NonBlanks?

    Thanks a lot,
    CT

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Use the query builder for the RowSource of the combo box, in the WHERE criteria do something like

    WHERE (LEN(tblName.fldName) > 0)
    Me.Geek = True

  3. #3
    Join Date
    Jun 2009
    Posts
    95
    What does LEN stand for?

    Thanks,
    CT

  4. #4
    Join Date
    May 2005
    Posts
    1,191
    when you're in the query builder, put your cursor in the word and hit F1, that'll bring up the help on that word. This one just so happens to be the Length function (it gives you the number of chars in whatever string you pass it). It'll filter out any nulls or zero-lengths.
    Me.Geek = True

  5. #5
    Join Date
    Jun 2009
    Posts
    95
    Thanks a lot nckdryr.

    I appreciate your help.

    -CT

Posting Permissions

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