LimitToList property not working

W

Weezie1383

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!!
 
R

Rick Brandt

Weezie1383 said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top