Adding Color to Field names in a text box

[Castaway4]

Is there a way to change the font to a field name that was embeded to a text box on a report
ex. ="example in black " & [red color field name] & " back to black"

Thanks

 

[vbaInet]

You want to change the color of a textbox based on the value of a another textbox?

 

[Castaway4]

I am looking to have a text box with fields being embeded inside of it but want to change the color of the fields.

ex. ="The text box is in black " & [Field to be in red] & " and then back to black"

 

[vbaInet]

I don't understand your example. Give us a scenario.

 

[Castaway4]

Example

In one Text box

To find a drop-off location near you

 

[vbaInet]

Oh I see what you mean. You want to change the font colour of the concatenated field value in the textbox?

It can only be done using HTML in a Rich Text formatted textbox.

 

[Castaway4]

Can you give me an example of a HTML in a Rich Text formatted textbox

 

[vbaInet]

I can but what version of Access are you using?

 

[Castaway4]

Access 2002

 

[vbaInet]

Rich Text is only available from Access 2007.

You could however have a look at this:

http://www.lebans.com/richtext.htm