Table getting -1 and 0 values for yes and No in form

**pratim09** · 08-10-2011, 01:37 PM

I have a column in database with corresponding field in form with drop down values as Yes and No . When i do a update in the form the Yes is taken as -1 and No as 0 in table . The column datatype is text .Why is this happening. I want a yes or No in table also.

**Bob Fitz** · 08-10-2011, 01:49 PM

Hi
Change the "Display Control" property of that field in the table to "Text Box"

**pratim09** · 08-10-2011, 10:07 PM

Display control is set to text box only in table but still facing this issue

Table getting -1 and 0 values for yes and No in form

Thread Tools

Table getting -1 and 0 values for yes and No in form

Similar Threads

vba code to search and match table values to other table values

Multiplying Values from a form and table

paste values from one table to another table in form

Display values in a FORM from table.

Rounding off values in Form pivot table values

Posting Permissions