Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    austin, Texas, USA
    Thanked 0 Times in 0 Posts

    Limit to List = No! (Acc 2K, Win 2K Pro)

    I have a db with a look-up table to store names and intend to use the lookup table extensively in various forms where names need to be entered. the purpose is to maintain a list of names globally and to allow dataentry to key in enough chars to find and select a name in the list or, if it's not there, enter a new one. Frustratingly enough, when I setup the table with a lookup to the Name table and attempt to toggle Limit to List to 'No' I get the mysterious error "The first visible column, which is determined by the ColumnWidths property, isn't equal to the bound column." and am not allowed to make the bloody list accept new input. I suppose I can do some module-based SQL stuff instead but I'd like to know what in heck the width of a column has to do with allowing new data to be stored in a field linked to a combo box... <img src=/S/aflame.gif border=0 alt=aflame width=16 height=16>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Limit to List = No! (Acc 2K, Win 2K Pro)

    Say that you have a lookup table like this:

    <table border=1><td align=center>ID</td><td align=center>Description</td><td align=right>1</td><td>Apple</td><td align=right>2</td><td>Banana</td><td align=right>3</td><td>Pear</td></table>
    In another table, you have a number field that uses the lookup table. The dropdown list has 2 columns, of which the first one has width 0. So the user doesn't see the ID, only the Description, but the selected ID is stored in the field. If the user selects Banana from the dropdown list, the number 2 is stored in the field. But if the user would enter Mango, there is no way for Access to store the word "Mango" in the number field.

    On the other hand, if the lookup table looked like this:

    <table border=1><td align=center>Description</td><td>Apple</td><td>Banana</td><td>Pear</td></table>
    and if the field in the other table were a text field, the dropdown list would need to have only one column. If the user selects Banana, the word "Banana" is stored in the field, and if the user enters Cherry, the word "Cherry" is stored.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts