Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jul 2005
    Location
    North Carolina, USA
    Posts
    195
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Counting items on an unbound listbox (2003)

    Hi, I am trying to use the count expression on the bottom of my form any get the total of items on an unbound listbox (lstDiplay). i tried:

    =Count(*)
    =Count(Forms!frmName!lstDisplay)
    =Count(Forms!frmName!lstDisplay(Column (0,0))

    Any suggestions. I cant get this to work.

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

    Re: Counting items on an unbound listbox (2003)

    Count returns the number of records in a form, not the number of items in a list box. Try this:

    =lstDisplay.ListCount

Posting Permissions

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