Changing ColumnWidths (ComboBox) at runtime

[hufflehuffle]

Hi!

I have a small problem here, thanks for your ideas.

There is a ComboBox with two columns, first is an ID field, second is a
lookup expression showing a compound string. First column is hidden
(width = 0), second is displayed.

Problem: On Filter-By-Form, when the first column is hidden the filter
expression is generated based on the compound string and not on the ID
field. If I set the first column with to != 0, when closed the ComboBox
shows the ID only and not the compound string.

So when entering the Filter-By-Form, I want to change the
ColumnWidths-Setting of the ComboBox, but this does not seem to have
any effect at runtime.

Is there a solution for this?

Best regards.
Andreas

 

[Allen Browne]

This is a limitation of Filter-by-form - one of many actully.

You have outgrown it. Time to create your own filter options.

 

[hufflehuffle]

This is a limitation of Filter-by-form - one of many actully.

You have outgrown it. Time to create your own filter options.

I'd love to - unfortunately the customer won't pay for it (and I have
spent double the project time solving the filter-by-subform problem).

Best regards,
Andreas