Posted 29 January 2020, 10:06 pm EST
Hi Victor,
>>but if I use “IS QUALIFIED” it does not work.
Sorry it is working fine at our end. In our attached sample I have hide the rows that have “Sales Representative” value in the “Title” column.
>>How do I still change the width of the columns and caption when applying the code?
The code provided by you is working fine at our end. Please see the attached sample.
>>How do I include a second condition the length has to be greater the 16 otherwise hide the row?
Please find the below given code in our attached sample where both the conditions are working fine.
For j As Integer = 0 To C1TrueDBGrid1.Splits(0).Rows.Count - 1
If C1TrueDBGrid1.Splits(0).DisplayColumns("Title").DataColumn.CellValue(j).ToString.Contains("Sales Representative") And C1TrueDBGrid1.Splits(0).DisplayColumns("Title").DataColumn.CellValue(j).ToString.Length > 12 Then
C1TrueDBGrid1.Splits(0).Rows(j).Visible = False
End If
Next
All the above desired scenarios are working fine at our end, please modify the attached sample accordingly or provide your stripped down sample replicating the issue so that we can replicate the same issue at our end and provide you a helpful solution.
Regards,
Prabhat Sharma
TDBHideRowDemo.zip