Replace values with a "*"

Hi, i have a report which contains a table with several columns. The
first column is filled with some data from a database, and can contain
data, that is some cells can be empty, some can have values...
So my question is, how can i make all the cells in that column that
HAVE a value, to have the value of "*".
Col1 Col1
-- --
1 *
5 HAS TO BE
8 *
4 *
Thnx!Use an IIF built-in function in an expression for the other columns textbox.
David
"ApeX" <jkdmaster_5@.hotmail.com> wrote in message
news:1186655248.283959.105240@.l70g2000hse.googlegroups.com...
> Hi, i have a report which contains a table with several columns. The
> first column is filled with some data from a database, and can contain
> data, that is some cells can be empty, some can have values...
> So my question is, how can i make all the cells in that column that
> HAVE a value, to have the value of "*".
> Col1 Col1
> -- --
> 1 *
> 5 HAS TO BE
> 8 *
> 4 *
> Thnx!
>|||put this in col2 field
=Iif(fields!Col1.value<>'', '*', fields!col1)
"ApeX" wrote:
> Hi, i have a report which contains a table with several columns. The
> first column is filled with some data from a database, and can contain
> data, that is some cells can be empty, some can have values...
> So my question is, how can i make all the cells in that column that
> HAVE a value, to have the value of "*".
> Col1 Col1
> -- --
> 1 *
> 5 HAS TO BE
> 8 *
> 4 *
> Thnx!
>