If you are doing this in datasheet view for a query or a table,
then NO you cannot cannot change the font color for just one
record.
In a report, you can do so.
On a form, you might be able to do so with conditional formatting.
If you can do it on a form, you can do it on a datasheet, I think,
since a datasheet is a form object. You'd have to use
Screen.ActiveDatasheet to do it, and reset the conditional
formatting each time you opened the datasheet, but I expect it's
completely doable (though the syntax for setting conditional
formatting in code is a little wonky, seems to me).
