Help with setting FilterDropdown in C1TrueDBGrid For all columns

Posted by: Victor.m.charles.civ on 8 April 2020, 12:34 pm EST

  • Posted 8 April 2020, 12:34 pm EST


    How do you modify the code below to set a loop to FilterDropdown for all the columns in a Grid. Instead of setting a filter for each column.

    Me.C1AOP5.Columns(0).FilterDropdown = True
    Me.C1AOP5.Columns(1).FilterDropdown = True
    Me.C1AOP5.Columns(2).FilterDropdown = True


  • Marked as Answer

    Replied 8 April 2020, 8:10 pm EST

    Hi Victor,

    You can use the code snippet given below to set a loop to FilterDropdown for all the columns in a Grid
    For i = 0 To C1AOP5.Columns.Count - 1
    Me.C1AOP5.Columns(i).FilterDropdown = True

    Prabhat Sharma.

  • Replied 9 April 2020, 11:27 pm EST

    Thank you. It's nor working for some reason, is there any other setting in the grid that would prevent it from working?
  • Replied 12 April 2020, 10:24 pm EST

    Hello Victor,

    Sorry but we can not replicate the issue at our end and filter dropdown appears for every column using the above-given code snippet.

    You can look into the attached sample implementing the same and modify it accordingly replicating the issue.

    Prabhat Sharma.
  • Replied 12 April 2020, 10:40 pm EST


    It's working.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels