Triple state check boxes in datasheet view

M

Mario Howard

In Access 2003 triple state check boxes in datasheet view
do not display the correctly. -1 is displays checked, 0
displays blank and Null also displays blank instead of
grayed out like in Access 97 & 2000. Why, is this a bug?
Does anyone know how to fix this? (In form view the check
boxes display correctly)
 
A

Allen Browne

Unbound triple-state checkboxes do function correctly. The problem is with
their display if you use Access 2003 on Windows XP.

You could try unchecking this option:
Tools | Options | Forms | Use Windows Themed Controls on Forms

Alternatively, turn off the Windows XP themes by right-clicking the Windows
desktop, choose Properties, and setting the Theme to "Windows Classic".
 
G

Guest

Thank you for your help.

What do you mean by: "Unbound triple-state checkboxes do
function correctly"? Unbound controls do not make sense in
DataSheet View. In Forms View bound triple state CheckBoxes
also work correctly.

The state of "Use Windows Themed Controls on Forms" has no
infuence on the display of triple state CheckBoxes.

Reverting to "Windows Classic" works but that cannot be
seriously considered as a workaround or a fix.

Micosoft should fix this. If you can please let them know
since common mortals like me have no way of reporting bugs
to Microsoft.
 
A

Allen Browne

The Yes/No field in Access (JET) does not support the Null value, so a bound
checkbox in an Access database won't work triple state regardless of the
property setting.

Dropping the WinXP themes is the only workaround you have, and also solves
several other unfixed display issues in Access, including erroneous metrics
(e.g. scrollbars that don't work), screen flicker, and so on.

But there are far more serious bugs in Access, where it loses your data,
omits records from queries, sorts wrongly, filters incorrectly, gives wrong
results from comparions, ... things that are *very* basic to a database.
Believe me, I have wasted considerable energy trying to get these
long-standing, basic bugs fixed, without success. So all I can do is warn
people where the flaws are:
http://members.iinet.net.au/~allenbrowne/tips.html#flaws

Please do provide feedback directly to Microsoft. Who knows: they might
start to listen if enough people let them know what you think. This link
should take you to the product feedback page:
http://go.microsoft.com/fwlink?linkid=23651
 
G

Guest

My triple state chek boxes are bound to Integer fields. I
have used this extensively in Access 97 and 2000. For me it
is a serious problem that this does not work anymore in
Access 2003!

Thank you for your suggestions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top