I have an Access database that stores MS Project names and file locations, and when asked to creates a new MS Project from the files in the database for resource planning. Fine so far! Have just been asked 'Can the active porjects be shown in a different colour?' No problem I said as the project status in show in the database. WRONG.

My question is:
What is the VBA syntax to change a row font colour in Project when the VBA code is in Access. Can it in fact be done?