Recent content by tjarus

That is almost exactly what I am doing - I have a list of NDCs similar to UPCs but pharmaceuticals with additional information and I want to see when the NDC changes. I might give this a shot just to see what happens or it might trigger something else. Thanks!

So what I gave was a simple example and not at all what my data actually is - but I might be able to do that Format column - I'm guessing you have code that looks at the field to determine True or False? Rerunning the table wouldn't be out of the question either. I have about 40,000+ rows of...

Thanks for the reply. I've already been to that link and it's not what I'm wanting to do. I want to change the entire row color when the value changes. Let's say I have 8 columns of data, in one column, there are repeating values that are sorted together, such as, a list of people and their...

Hi! My name is Terri and i'm from St. Charles, Missouri in the USA. I've worked a lot with Access in the past but it's been several years - so lots of new Access functionality that I've found is really cool! So much easier to do some things. I've recently picked up a consulting job to design...

I know how to use Alternating Row Color (using Access 2016), but I need to be able to change the row color when the value in a field changes. Datasheet view, when the value changes in the SmartKey column I want to change the row backcolor. I've googled but not been able to find anything for...