Expression statements in a report

[spooner]

Hi all,

Can't get any luck with using expression statements and even though i've tried a few statements after following a few tutorials on the exp builder which resulted in no luck.

The following refers to the attached.

'A' will be set as a label with a date format (just haven't got around to it)
- how do i change 'a' depending on the date (chosen which i will use a macro builder for)

-how to use the expression builder to change the colour /load image (of 'B') depending on whether the date in 'A' is between 'Start date' and 'End date'
-is it possible to put a conditional statement (if function) within another conditional statement.

Many thanks for any help

 

[Minty]

I can't help you with macro's but You can use conditional formatting to change the format of a text box control. (Not a label)

So if your control was called ReportDate you can use condutional formatting to change it's colour / font weight etc.

You can't use IIF's in conditional formatting, but you can have multiple conditional expressions.

 

[spooner]

Thanks Minty,

Could you please give me an example of the line of the code for the expression to do this?

 

[Minty]

Click on the control then click on the conditional formatting. You can enter simple expressions using the actual value of the box or you can base it on other fields using the expression option. So if you had a field called LatestDate you wanted to compare with today's date you would enter;

[LatestDate] <= Date()
and then set your format accordingly, you could add second on the same control afterwards ;

[LatestDate] > Date()