LimitToList property not working

[Guest]

Hi,

I have created a form with a query built behind it which allows users to
type in wildcard searches. I am trying to set the LimitToList option in the
properties to "No" to allow my users to actually conduct a wildcard search
but everytime I try and set it to No I get the message:

"Cant set the LimitToList property to No right now. The first visible
column, which is determined by the ColumnWidths property, is not equal to the
bound column. Adjust the ColumnWidths property first, and then set the
LimitToList property."

Can someone please explain to me what this means and how I can correct it?

Thank you!!

 

[Rick Brandt]

Hi,

I have created a form with a query built behind it which allows users
to type in wildcard searches. I am trying to set the LimitToList
option in the properties to "No" to allow my users to actually
conduct a wildcard search but everytime I try and set it to No I get
the message:

"Cant set the LimitToList property to No right now. The first visible
column, which is determined by the ColumnWidths property, is not
equal to the bound column. Adjust the ColumnWidths property first,
and then set the LimitToList property."

Can someone please explain to me what this means and how I can
correct it?

Thank you!!

If you set up a ComboBox so that it displays one value while storing another
(common scenario) then LimitToList cannot be turned off. The reason is clear if
you think about it. How does a user cause a value to magically appear in the
hidden column simply by typing a new value in the visible one?