Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbphoenix
Yak Posting Veteran
68 Posts |
 Posted - 2012-06-19 : 11:00:04
|
| For the placeholder properties of one the textboxes in my table I've changed the Markup type to HTML. I've made some of the data bold using html. However when I did this, the spacing I had included in the value is now being ignored. Anyone know how to add spacing between strings?Here is the expression I have now - ="<b>" & "MAWFA Total: " & "</b>" & IIf(IsNothing(Fields!Cnt_MAWFA_Gifts.Value), " " , FormatCurrency(Fields!Dol_MAWFA_Gifts.Value,0) & "/" & Fields!Cnt_MAWFA_Gifts.Value & " gifts") & "<b>" & " Recent: " & "</b>" & IIf(IsNothing(Fields!Rec_Gift_Date.Value), " ", FormatCurrency(Fields!Rec_Gift_Dol.Value,0) & "-" & FormatDateTime(Fields!Rec_Gift_Date.Value, DateFormat.ShortDate) & " (" & Fields!Rec_Gift_Fund.Value & ")") & "<b>" &" First: " &"</b>" & IIf(IsNothing(Fields!First_Gift_Dol.Value), "", FormatCurrency(Fields!First_Gift_Dol.Value,0) & "-" & FormatDateTime(Fields!First_Gift_Date.Value, DateFormat.ShortDate) & " (" & Fields!First_Gift_Fund.Value & ")") |
|
|
jbphoenix
Yak Posting Veteran
68 Posts |
Posted - 2012-06-19 : 11:22:05
|
| I figured how to accomplish what I needed by using <br />. |
 |
|
|
|
|
|
Placeholder html