I am working in an access 2010 database and have a memo field that is set to rich text. I would like to select all text in this field and change the font color. It is too time consuming to select the text in each row and change the formating. I was wondering if I could do this in an expression on a qry where I am combining two fields [sub question] & [answer]. I would like the "answer' to appear in red. Or could I do this in the SQL view? Thank you for your help.