Different print formats in one expression?

[kara2003]

Access 2003: My report generates a paragraph that reads:

...... "requests payment in the amount of "
& bill_amount
& spell_number(bill_amount)
& " representing expenses for the period "
& format(effdate_from)
& format(effdate_to)

I contained them all as an expression in one textbox. However I would like to format the Amount in Words as bold and underlined (in my example - spell_number(bill_amount)). I tried separating them into several textboxes placed side-by-side hoping the "Can Grow" and "Can Shrink" properties will work for me , however, they "grew" downwards and not left-to-right as I would want them to.

My users are quite content with the flat format, but I'm not. Any help?

 

[kjv1611]

What about this?

Instead of text boxes, use labels... I think labels have more flexibility for formatting.

Then, use your VBA code to set the widths of the labels (or text boxes, if you want to stick with that) according to the length of the text?

--

"If to err is human, then I must be some kind of human!" -Me

 

[dhookom]

Be quite content also unless you want to use a ton of code or a rich text control.

Duane
Hook'D on Access
MS Access MVP