limit to list property

[wolfm]

New Props Tracker - Revised.zipI have a form on the attached database called “JobsRedo”. I want the user to be able to enter a value not on the value list, as many items are custom items.
When I try to change the property of the orders table field called “Item”, I get an error. Has something to do with column widths. I do not understand. I have been frantically adjusting column widths, to no avail.
The error message I receive:
Limit To List property cannot be changed to No.
The first visible column which is determined by the Column Widths property isn’t equal to the bound column. Adjust the column widths property first and then set the LimitToList property.



What are the supposed column width rules I am supposed to follow, to allow this to happen?

Thanks for any help!

[Missinglinq]

...The first visible column which is determined by the Column Widths property isn’t equal to the bound column...

Currently, the first visible column is Column 2 , while the Bound Column is 1; you need to change this:

In Form Design View

1. Select the Combobox
2. Go to Properties - Data
3. Change the Bound Column Property from the current #1 to #2
4. Now you can change the Limit to List Property to No
   

Linq ;0)>

[ssanfu]

Two suggestions:

1) Remove the look up fields in table "Orders". See http://access.mvps.org/access/lookupfields.htm (and also http://access.mvps.org/access/tencommandments.htm)


2) The "ID" fields should not be displayed on the form because they are Autonumber types.
"An Autonumber field is simply a way to create a unique identifier for each record. It should NEVER be treated as a meaningful piece of data."

See
Autonumbers--What they are NOT and What They Are
http://www.utteraccess.com/wiki/index.php/Autonumbers


Microsoft Access Tables: Primary Key Tips and Techniques
http://www.fmsinc.com/free/newtips/primarykey.asp


Use Autonumbers properly
http://access.mvps.org/access/general/gen0025.htm