by Jonathan Halder | Mar 12, 2024 | MS Access, MS Access VBA Coding, TDD
I am currently exploring the phenomenon that happens to different fields in a form that are bound to the same underlying table field. For an example I have two text fields (TestText and TestTextAlso) on a form that are both bound to the same underlying TestText column...
by Jonathan Halder | Mar 11, 2024 | MS Access, MS Access VBA Coding, TDD
Last time I was curious about this topic. What happens in the BeforeUpdate event to two separate controls that are bound to the same column? So rather than wonder what would happen… how about we test for the behavior we would want in this situation… which...
by Jonathan Halder | Mar 8, 2024 | MS Access, MS Access VBA Coding, TDD
Our next test will be to add an Option Group to the form and test that. Now Access has some weird caveats for option groups. You can have radio buttons, checkboxes, or toggle buttons in an Option Group. Each button or box can be labeled, but can only have a numeric...
by Jonathan Halder | Mar 7, 2024 | MS Access, MS Access VBA Coding, TDD
Yesterday I added a test for a triple state checkbox which should allow null, and True/False values to be set. I was reminded as I had initially tried to use an Access Yes/No field type that this does not have triple state. It can never be null, so therefore will not...
by Jonathan Halder | Mar 6, 2024 | MS Access, MS Access VBA Coding, TDD
Now I am going to add a triple state checkbox to the form. I have added a new text field that can be nullable, and bound a new “TestCheckTripleState” checkbox to it. The reason for this is that a “Yes/No” Access field cannot be null. It can...
by Jonathan Halder | Mar 5, 2024 | MS Access, MS Access VBA Coding, TDD
I’m going to start the next test with something simple. A new type of field. I will add a checkbox to the test form and bind it to a Yes/No field and write a test to check to see if it updates the values as expected. I added the checkbox to the form, added a new...
