Report Formatting

[Guest]

This is what I do to format an amount in currency in a trim function:

=trim("The amount of " & Format([amount], "currency") & "is due on september")

Can somebody tell me if I can use the "Format" with the code to bold words
in the trim sentence above? That's it, I want to format the word "amount" on
the trim shown above. Instead of using "currency" can I use something else to
bold some words?

 

[Duane Hookom]

First, Trim() is not necessary in the expression.
Second, you can't set more than one format in an Access text box. There may
be some other rich text format controls that allow this. Stephen Lebans
hosts the most solutions like this at www.lebans.com.