Changing text color

[BSando]

I am importing data from a spreadsheet and using a update query to oput the data into its correct table. What I want to do is if the data is changed during the update, I want to change the color of the text. Is this possible?

Thanks in advance

Some people make things happen, some watch while things happen, and some wonder 'What happened?'

 

[dhookom]

If you kept the old value someplace you could probably use conditional formatting or code to change the format of the changed data values.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[BSando]

I have created a text box that updates with the current date when the field is changed.
So it should now be easier. I think. Do I create a module to change the text to Bold and put the module in the query for the form or should I put the module in the form somewhere?



Some people make things happen, some watch while things happen, and some wonder 'What happened?'

 

[dhookom]

Can you create any kind of expression that could be used to determine which records should be bolded?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.