If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Make Field Data BOLD when imbedded in TextBox

Thread starter KniteMare
Start date Nov 5, 2003

KniteMare

Board Regular

Nov 5, 2003

Aloha

Here is the Control Source:

="Total overtime hours for the week ending " & [qryThisFY.WeekEnding] & " were " & [qryThisFY.GrandTotal] & ". Overtime hours for this period last year were " & [qryLastFY.GrandTotal] & ". Equating to a" & IIf([qryThisFY.GrandTotal]-[qryLastFY.GrandTotal]>0,"n increase"," decrease") & " of " & [qryThisFY.GrandTotal]-[qryLastFY.GrandTotal] & " Hours."

Is it possible to make the values returned within the [....] brackets BOLD while keeping all the other text Medium?

I have done this before by breaking up the TextBoxes and carefully placing them side by side. The problem is asthetic. If the numbers change dramaticly they either overlap the text or leave a gap.

Yours in inACCESSable frustration

KniteMare