Can someone please help me with the following question. I thank you for your help and time in advance.
I have a subform inside a form that displays as Datasheet view. My goal is to highlight the cell when a change occurs.
For example, the Datasheet consists of 4 columns: TaskID, TaskName, CustomerName and Budget($). When the user changes the TaskName of TaskID #102, I would like to see the Backcolor of the TaskName TaskID#102 change color to signify that there was a change(color configuration). The user than moves to TaskID#300 and changes the Budget value from $100 to $200, then I would like to see the Budget cell to change color as well.
I have tried the conditional formatting that comes with MS Access and it did not work. Is there a way I can accomplish this procedure using VBA. Again, thank you for your help.
I have a subform inside a form that displays as Datasheet view. My goal is to highlight the cell when a change occurs.
For example, the Datasheet consists of 4 columns: TaskID, TaskName, CustomerName and Budget($). When the user changes the TaskName of TaskID #102, I would like to see the Backcolor of the TaskName TaskID#102 change color to signify that there was a change(color configuration). The user than moves to TaskID#300 and changes the Budget value from $100 to $200, then I would like to see the Budget cell to change color as well.
I have tried the conditional formatting that comes with MS Access and it did not work. Is there a way I can accomplish this procedure using VBA. Again, thank you for your help.
