Limit To List Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form where I That has 3 columns. I want to use all 3.
I set the column width to 0;1;1;1
When I try to change the Limit To List to No I get message that doesn't
allow this and doesn't let me set the Limit To List to No.
 
CyndyG said:
I have a form where I That has 3 columns. I want to use all 3.
I set the column width to 0;1;1;1
When I try to change the Limit To List to No I get message that doesn't
allow this and doesn't let me set the Limit To List to No.
Click to expand...

You have four column widths (is that a typo)?

Limit to List can only be No when the bound column is also the displayed column
(left-most column with a non-zero width). That is the only way that what the
user types can be saved.

Imagine I display the values "One", "Two", "Three" from column 2 but am storing
the values 1,2,3 from hidden column 1. If the user types "Four" what value
gets saved? Access has no value from the hidden column that corresponds to an
entered value of "Four" so this is not allowed.
 
I posted another question so I can better understand about column
widths,bound colums and Limit to list.
 
CyndyG said:
I posted another question so I can better understand about column
widths,bound colums and Limit to list.
Click to expand...

You only have three columns but you specify four widths, the first one being
0.
Set the column width to 1;1;1 in order to be able to use Limit to List.

Tom Lake
 
Back
Top