Displaying Checkbox Data

I have a dataassist form that only displays the data (0 or 1) from my table if the field in text. When I set the field as a "Checkbox" field in the Data Assist Wizard, the field is not checked even though the value is a 1 in the database.

How do I display data for a Check Box. I also have the same problem for drop-down menus.

Thanks.

Select the checkbox in design view. In the property inspector, click the Dynamic button.

Clickthe lightning bolt next to Check IF and select the corresponding Recordset column. In the Equal To box, type the number "1"


For select lists, you have click the dynamic button in the property inspector as well. Click the lightning bolt next to select value equal to and select the corresponding recordset column.

My Checkbox is a Yes/No field in an Access Database, so if the box is checked, the value = TRUE. (this is what is shown in an Excel export)

However, I tried TRUE, Yes and 1. None of them showed the proper selection. That is when I noticed that on my DataAssist Update page the value was True as opposed to TRUE. I changed my rule to True and it works fine.

Just found this interesting and thought I would share it for others. Case sensitivity is not normally an issue with an MS Server and in this case, the case seems to change in ASP from it's native format.