Formating of text depending on hidden fields

[fat controller]

I have a report that has two fields - [TS] and [AltTS]

TS will always have text in it, whereas AltTS won't necessarily have anything in it.

In the event that there is nothing in the field [AltTS], I would like a textbox on the report to show just the value that is in the field [TS]; However, if there is a value in AltTS, I would like that textbox to show the value from TS and then the value of AltTS in brackets.

So, if TS had a value of 56, and AltTS had a value of 59, then the texbox would show 56 (59);

I am thinking along the lines of an unbound textbox and then putting the information in maybe in the On Format event of the report?

 

[Minty]

Create a calculated field in the underlying query . Something like

txtThing : IIF(AltTS is Null, [TS] , [TS] & "(" & [AltTS] & ")")