I have a combobox with a rowsource to a linked table.  The Format property 
is set.  When the Limit to List property is set to true, the combobox 
works fine.  However, when I set Limit to List equal to false, choosing 
the SAME value off the list gives me this error message:  "The value you 
entered isn't valid for this field."

The value IS valid for the field.  The only thing I changed was the Limit 
to List from true to false.  I need to have this field's Limit to List set 
to false.

What gives?  >:^|

Note, I can get this false error to stop if I set the Input Mask 
property.  Apparently, that false error message has something to do with 
formatting vs. inputting.

Greg

It sounds like this may have something to do with the "type" of data. What type of format do you have set? Any input mask? Is this a
numeric or text input? What are the values that are in the list?
 Gregory Serrano wrote:I have a combobox with a rowsource to a linked table. The Format property 
is set. When the Limit to List property is set to true, the combobox 
works fine. However, when I set Limit to List equal to false, choosing 
the SAME value off the list gives me this error message: "The value you 
entered isn't valid for this field."

The value IS valid for the field. The only thing I changed was the Limit 
to List from true to false. I need to have this field's Limit to List set 
to false.

What gives? >:^|


Lonnie Johnson 
ProDev, Builders of MS Access Databases
Check me out ==> http://www.galaxymall.com/software/PRODEV 




---------------------------------
Do You Yahoo!?
Yahoo! Health - Feel better, live better

Lonnie,

<< It sounds like this may have something to do with the "type" of data. 
What type of format do you have set? Any input mask? Is this a numeric or 
text input? What are the values that are in the list? >>

The table is linked (not mine).  The data is a type of Double (holds an 
eight- to ten-digit numerical code).  The Format is "0-00-000-00".  I put 
an input mask on my form's text box as:

   999\-99\-999\-99!;0;_

Once my input mask was in, the error stopped.  The original table owner 
does not have an input mask in the table for this field.  I would prefer 
this field be text because we're not doing math on the numerical code, but 
alas, it's not mine.

Greg

Sorry to say it looks like you are stuck with the imput mask unless you 
can get the owner of the table to change the data type. The values in the 
table are numeric and with an input mask you can show other types of 
characters like - / etc but they are not stored in the field because they 
are not numeric. Without the mask, if your user enters anything other than 
a number you will get the error because the field is expecting a numeric 
value.

The only other solution would be to unbind the combo box and translate 
whatever the user enters to a number but that does not seem like a good 
solution. I would work with the person who owns the table to get it 
changed to text if no calculations are done on the data.

Sorry couldn't help more,

Amy

> Lonnie,

> << It sounds like this may have something to do with the "type" of data. 
W> hat type of format do you have set? Any input mask? Is this a numeric 
or 
t> ext input? What are the values that are in the list? >>

> The table is linked (not mine).  The data is a type of Double (holds an 
e> ight- to ten-digit numerical code).  The Format is "0-00-000-00".  I 
put 
a> n input mask on my form's text box as:

>    999\-99\-999\-99!;0;_

> Once my input mask was in, the error stopped.  The original table owner 
d> oes not have an input mask in the table for this field.  I would prefer 
t> his field be text because we're not doing math on the numerical code, 
but 
a> las, it's not mine.

> Greg