How can I change font "mid-stream" in a text box in Access 2010?

You can use a RichTextBox in 2010, and then format it using standard HTML or RTF commands. HTML is by far the simplest way to deal with text formatting, as RTF can be very difficult to get right.

An example would be:

This is the first font and <font face="verdana">This is the second font!</font>

Scott,
Thanks for the reply.  I can't change it to a RichTextBox in report design view.  My table only contains the value that's sandwiched in the middle of the text currently.  How would I go about setting this up?
Chris

Sorry, I didn't explain myself well.

You must change the Textbox from "Plain Text" to "Rich Text" in design view. This is on the property sheet Data tab.

My table only contains the value that's sandwiched in the middle of the text currently

I'm not sure what you mean by that.

Thanks!! I got the text box into Rich Text. I have a problem now when I try this an error message pops up: The expression you entered contains invalid syntax.
This is my text box where I just tried changing the font on the word "all":
="                   THIS CERTIFIES THAT " & [TRANSFEREEVESTING] & " is the owner of one membership Series of " & [LONGNAME] & ", a non-profit mutual benefit California Corporation which may not make distributions to its members except upon dissolution, and is entitled to <font face="verdana">all </font>the benefits and privileges of membership in said Corporation, and subject to all of the terms, conditions, and restrictions, as set forth in the Articles of Incorporation, By-Laws, and Occupancy Agreement of said Corporation."

Thanks for the help...this one is new to me.

Sorry...in this case I am using 2013...I am unfortunately using 2010 and 2013 in different offices to work on the same database...maybe that's causing problems with this?

If you remove the <font ..> tags, does it work as expected?

What is [TRANSFEREEVESTING]? If that's a Field or Control, you should preface it with the correct qualifier. For example, Me.TRANSFEREEVESTING.

Yes, without the font tags it's fine (except it's all one font of course).

Yes, [transfereevesting] is a field containing a text value.  This is the field that I need to be a different font than the remainder of the text box.  I've never had to preface one of these with a qualifier before, I've always just concatenated it into the rest of the text with ampersands.

Thanks.

Sorry - been a while since I worked with Rich Text. You have to use a different format when saving.

Here's an example of a Rich Text field that I created and then modified the font and such using the interface,

<div>Test to <strong>determine how</strong> Access stores this for<font face=Belgium> </font><font face=Belgium color=red>rich text</font>.</div>

Select allOpen in new window

You can see it's enclosed by <div> tags, so change your code to show this sort of structure. Also, note that that attributes of the <font> tag are NOT enclosed in single or double quotes. The exception to that would be if an attribute value contains a space. For example:

<div><u>Your Original Text Here</u> with the <font face="Arial Black" color=red>new font here</font></div>

Select allOpen in new window

Note in the above I've chosen Arial Black, and Access stored it with double quotes around the name.

Thanks!  I'll try on Tuesday when I get back to work.  Before then, I still have questions:

I guess this is all preceeded by an equal sign and quotes to enclose the text except around the field name, and that I should use the same end-quote + ampersand + [field name] + open-quote + remaining text.

="<div>Beginning text "& <font face=verdana>[transfereevesting] </font>& "<font face = arial>the remaining part of the text</div>"

Thanks for all your help, Scott.