joanne2468
asked on
changing font color in MS Access 2010 expression
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.
Joanne
Joanne
IrogSinta
Can you describe this a bit more? I don't quite understand what you're trying to achieve. If you can post a screenshot, that may make it clearer.
ASKER
I have a MS database that has two tables. One table has questions and answers from a questionnaire and one table has an action plan.
I have the [question], [subquestion] & [answer] fields set as memo fields in table1. I have the [action] field and [comment] field in table2 set to memo also. Both of these tables were imported to the database from Excel. I have a query where I have expressions that combine the [question] & [answer] fields and another expression that combines the [action] & [comment] fields.
Since you can set memo fields to rich text it allows you to select (one word or multiple words) in a field and change the font color, size, etc. and it will only do this in the one field on the text selected. If I change this at the table level it will have that change in the report. So in my report the question field is black and the answer is in blue (to help with reading)
My question is can I select all of the text in the field and change all of the font color for only that field at the table level OR can I do this when I build the expression in the query?
For example my expression is:
=[subquestion] &": "& [answer]]
is there a way I can put some type of vb code before [answer] that will change the font to blue? Or could I put this in the SQL view of the query?
I am at home and don't have access to the database to where I could provide a screenshot. Any help you can provide would be appreciated.
Joanne
I have the [question], [subquestion] & [answer] fields set as memo fields in table1. I have the [action] field and [comment] field in table2 set to memo also. Both of these tables were imported to the database from Excel. I have a query where I have expressions that combine the [question] & [answer] fields and another expression that combines the [action] & [comment] fields.
Since you can set memo fields to rich text it allows you to select (one word or multiple words) in a field and change the font color, size, etc. and it will only do this in the one field on the text selected. If I change this at the table level it will have that change in the report. So in my report the question field is black and the answer is in blue (to help with reading)
My question is can I select all of the text in the field and change all of the font color for only that field at the table level OR can I do this when I build the expression in the query?
For example my expression is:
=[subquestion] &": "& [answer]]
is there a way I can put some type of vb code before [answer] that will change the font to blue? Or could I put this in the SQL view of the query?
I am at home and don't have access to the database to where I could provide a screenshot. Any help you can provide would be appreciated.
Joanne
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much. I appreciate your help.