I have a text box in an Access 2010 report. Mostly it is pre-typed text, but has the value of a text field sandwiched in between. I would like to have the first part of the text box one font, then have the text value another font, and then return to the first font for the rest. I would like to have it all within one text box so that it wraps correctly, and can grow or shrink if necessary.
I looked for some kind of formatting string I could insert, such as
="This certifies that"&[namefield]&"is a member of the organization" would turn into ="This certifies that"&Format([namefield], fontname)&"is a member of the organization"
but could find no such thing.