I am designing a form that contains tristate check boxes. The function of the boxes and the values that they generate appear fine. However, the "grey" (null) state is not visable. the checkbox never visibly greys out - it just looks unchecked.
I found a similar question from back in 2005 here in EE forums Q_21445513 "Tristate CheckBox state not visible when 'grey' on Flat Screen displays" that indicates that this was a bug in MS Access 2003 that MS was going to address back in 2005. But now it is Oct 2006 and I am fully patched and the issue still exists.
This application is used in an uncompiled state, so using a prior version runtime (as was the solution to Q_21445513) is not an option for me.
Access 2003 display issues continue on - regardless of SP's.
If it's a huge issue place a small textbox next to the checkbox that just re-iterates its value.
=IIF(Isnull(Checkbox), "Unselected", IIF(Checkbox,
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro: