This topic is locked

Checkbox

9/10/2009 12:17:37 PM
ASPRunnerPro General questions
L
luic author

A field is defined as checkbox. The checkbox graphic (check_yes) is shown up in the view screen when it is true. However, when the field is null or false, there is no box coming up like (check_no) in the view screen. Is there any way to make the check_no graphic showing?
Chris.

Sergey Kornilov admin 9/10/2009

Sounds quite strange. Probably it depends on field datatype. If you use Yes/No field in MS Access or tinyint in SQL Server you won't face this issue.
If more help is post your application to Demo Account (use 'Demo Account' button on the last screen in program). Then open a ticket at http://support.xlinesoft.com sending your Demo Account URL for investigation.

L
luic author 9/10/2009



Sounds quite strange. Probably it depends on field datatype. If you use Yes/No field in MS Access or tinyint in SQL Server you won't face this issue.
If more help is post your application to Demo Account (use 'Demo Account' button on the last screen in program). Then open a ticket at http://support.xlinesoft.com sending your Demo Account URL for investigation.


Thanks. The data type I used in SQL Server is bit data type, 0 or 1. Can you advise me how to make the change temporary to include this data type?

Sergey Kornilov admin 9/10/2009

I guess you can use "View as" type "Custom". You can check field value and display one of images depending on field value.

P
Philip 9/14/2009

Chris
I had once the same problem (can't remember in which version).

Solution was to assign to the field in Access a default value of 0 (zero).
Philip