Access JumpStart 2.0 | Blog

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...

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...

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...

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...

With the new set of functions that I've refactored last time, I'm going to update the other functions to use them. So let's go back to the first 3 counting tests and use the dictionary creation function to make them more readable. Here they are now:...

I'm going to add a data element to our collection so that the user of our Form Auditor class will have the bound field name from the ControlSource property. First I will add a new test to check for this additional field in order to have a failing test, then I can...

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 begs the...

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 only be true or false which...

This test I refactored yesterday to use the new functions which all the tests are using. '@TestMethod("Count Changes") Private Sub WhenTwoFieldsAreChangedThenReturnTwoEntryListOfChanges() Dim testFormAuditor As FormAuditor, dctInput As New Scripting.Dictionary Set...