Format Font Within Formula? 1

[ddnh]

I use the following formula in my report header to show the parameters entered:

If {?chOrderDate} = false then
"Order Date is between " + ToText({?dtpFromOrderDate}) + " and " + ToText({?dtpToOrderDate})
else "Order Date is NOT between " + ToText({?dtpFromOrderDate}) + " and " + ToText({?dtpToOrderDate})

I'd like the parameter fields and the word "NOT" in bold. Is it possible to do this within the formula?

 

[mbarron]

You can do this by changing the Text Interpretation on the Paragraph formatting tab (under Format Field) to HTML. Then simply use HTML tags around the areas that you want to show as bold.

I've added the tags to the first parameter and the "NOT" as examples below.

Change you +'s to &'s

If {?chOrderDate} = false then
"Order Date is between " & "<b>" & ToText({?dtpFromOrderDate})&</b>" & " and " & ToText({?dtpToOrderDate})
else "Order Date is & "<b> NOT </b> between" & ToText({?dtpFromOrderDate},0,"") & " and " & ToText({?dtpToOrderDate},0,"")


Mike

 

[ddnh]

Thanks, that worked just fine.