hi there, i have question..i have a table which i fill with data form
a database...
Col1 Col2 Col3
---
=Fields!.. =Fields!... =Fields!
Col1 is filled with some text and has like 15 rows, and Col2 and Col3
are its values...So my question is - is it possible to have certain
values from Col1 to be BOLD, for example i want to have the fourth and
sixth row value for Col1 to be BOLD text...
THNX!Maybe you can place each of your 15 rows in Col1 in one detail row in your
table, so you can apply specific format in every separated row.
Does it help?
"ApeX" <jkdmaster_5@.hotmail.com> escribió en el mensaje
news:1187248049.501166.88240@.19g2000hsx.googlegroups.com...
> hi there, i have question..i have a table which i fill with data form
> a database...
> Col1 Col2 Col3
> ---
> =Fields!.. =Fields!... =Fields!
>
> Col1 is filled with some text and has like 15 rows, and Col2 and Col3
> are its values...So my question is - is it possible to have certain
> values from Col1 to be BOLD, for example i want to have the fourth and
> sixth row value for Col1 to be BOLD text...
> THNX!
>|||On Aug 16, 3:07 am, ApeX <jkdmaste...@.hotmail.com> wrote:
> hi there, i have question..i have a table which i fill with data form
> a database...
> Col1 Col2 Col3
> ---
> =Fields!.. =Fields!... =Fields!
> Col1 is filled with some text and has like 15 rows, and Col2 and Col3
> are its values...So my question is - is it possible to have certain
> values from Col1 to be BOLD, for example i want to have the fourth and
> sixth row value for Col1 to be BOLD text...
> THNX!
Try inserting this expression into the FontWeight property for the
cell you want:
=IIF(RowNumber(nothing) = 4 or RowNumber(nothing) = 6, "Bold",
"Normal")
That should work
toolman|||Your not going to be able to do it particularly gracefully if there's no
logic behind the decision.
What you can do is us a custom code block and put an expression on the
FontWeight property of yuor column.
Public Function GetFontWeight( _
ByVal columnValue As String) As String
If columnValue = "Col1" Or columnValue = "Col2 Then Return "Bold"
Return "Normal"
End Function
Expression on FontWeight property:
=Code.GetFontWeight(Fields!YourColumn.Value)
Joe
"ApeX" wrote:
> hi there, i have question..i have a table which i fill with data form
> a database...
> Col1 Col2 Col3
> ---
> =Fields!.. =Fields!... =Fields!
>
> Col1 is filled with some text and has like 15 rows, and Col2 and Col3
> are its values...So my question is - is it possible to have certain
> values from Col1 to be BOLD, for example i want to have the fourth and
> sixth row value for Col1 to be BOLD text...
> THNX!
>|||To follow up with what Joe said, if you have logic that determines which rows
you want bold it is possible. Simply put that logic in the FontWeight
property of the cell (either using the custom code joe suggested or a simple
IIF statement). You will, however, have to bold the entire contents of that
cell. You won't be able to just bold certain words (wasn't sure if this was
your question).
Hope this helps...
"Joe" wrote:
> Your not going to be able to do it particularly gracefully if there's no
> logic behind the decision.
> What you can do is us a custom code block and put an expression on the
> FontWeight property of yuor column.
> Public Function GetFontWeight( _
> ByVal columnValue As String) As String
> If columnValue = "Col1" Or columnValue = "Col2 Then Return "Bold"
> Return "Normal"
> End Function
> Expression on FontWeight property:
> =Code.GetFontWeight(Fields!YourColumn.Value)
> Joe
> "ApeX" wrote:
> > hi there, i have question..i have a table which i fill with data form
> > a database...
> >
> > Col1 Col2 Col3
> > ---
> > =Fields!.. =Fields!... =Fields!
> >
> >
> > Col1 is filled with some text and has like 15 rows, and Col2 and Col3
> > are its values...So my question is - is it possible to have certain
> > values from Col1 to be BOLD, for example i want to have the fourth and
> > sixth row value for Col1 to be BOLD text...
> >
> > THNX!
> >
> >
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment