Help with setting FilterDropdown in C1TrueDBGrid For all columns

Help with setting FilterDropdown in C1TrueDBGrid For all columns

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

• 

  Victor.m.charles.civ

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 April 2020, 12:34 pm EST

  Hi,

  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

  Thanks,

  Victor

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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
  Next
  

  Regards,
  
  Prabhat Sharma.

• 

  Victor.m.charles.civ

  • Post Options:
  • Link
    Copy

  Posted 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?

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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.

  Regards,
  
  Prabhat Sharma.
  
  TDBFilteringDemo.zip

• 

  Victor.m.charles.civ

  • Post Options:
  • Link
    Copy

  Posted 12 April 2020, 10:40 pm EST

  Hello,

  It’s working.

  Thanks