Hi all, thought i would be a smarty pants and import some excel sheets into Access (even though i've pretty much never used access before) in order to create a DB that i could essentially use as a reinventory tool. I created my tables, even nested them as subdata sheets, everything was going according to plan until i went to test it. My original plan was just to change the font color before i started so that any values i updated would be in red, while the rest of the values stayed black, pretty much how a spreadsheet would behave, but to my suprise, all the values turned red. So, my question to you all (keep in mind that i'm completely new to access) is how can i get access in datasheet view to only change the font color of the values i update? or even something similar so that when i get back to the office i can easily see which values i've changed?
Thanks,
Joe
Thanks,
Joe