conditional look....

Hi;
is there a way to control the look of the printing based on the data?..
i want to change the look of a textbox in a table, based on the value in my
query, for example:
Job desc Name Income
Emply John 5000
Emply Peter 5000
Sup Hugo 5000
Emply Rich 5000
I want to change Font style to bold, when Job desc is Sup
Is there a way to do it?
TIAOn Apr 14, 10:09 am, "Willo" <willobe...@.yahoo.com.mx> wrote:
> Hi;
> is there a way to control the look of the printing based on the data?..
> i want to change the look of a textbox in a table, based on the value in my
> query, for example:
> Job desc Name Income
> Emply John 5000
> Emply Peter 5000
> Sup Hugo 5000
> Emply Rich 5000
> I want to change Font style to bold, when Job desc is Sup
> Is there a way to do it?
> TIA
Sure. While in the Layout view, select 'F4' (or the View tab and
Properties Window).Select the cell(s) in the table that you want to
change the font style for and in the Properties Window open up [+]
Font. To the right of 'Font Weight,' select the drop-down menu and
select '<Expression...>' and enter something like the following:
=iif(Fields!JobDesc.Value = "Sup", "Bold", "Normal")
Regards,
Enrique Martinez
Sr. Software Consultant