creating strikethrough macro (1 Viewer)

[GGatcs]

I need to find out how to create a macro that will find a specified record in a table and then edit the record to the original recorded record but in a strikethrough font. I would also accept changing the font color from black to red.
Any ideas?

GG

 

[Atomic Shrimp]

This is one of the ways in which tables differ from spreadsheets, you can't format a single row of text to be different form the others.

But you can use 'conditional formatting' in A2000 in a form, which might give the effect that you're after.

It's also possible to do the equivalent of conditional formatting in A97, If you'd like a demo of this, please mail me and I'll send it by return

HTH

Mike