I have created a report with a few concatenated fields, I want to be
able to hide some defaults I have created in the concatenated field.

For example one of the fields has some car details:
=[CarModel] & " " & [CarColour]

I want to able to hide the CarModel and/or the CarColour if they meet
certain criteria, so for example the CarModel bit would not show if it
was a Ford. So no Ford's would show but the colour would unless it was
a Red then that would be hidden also.

Any ideas would be much appreciated for me to work around this problem.

On 01/11/2011 21:48:05, Dave wrote:
In the underlying query you will need clauses like

IIf(Left([ConcatField],5)="Ford ",Mid([ConcatField],6),[ConcatField])

This will turn "Ford Blue" into "Ford", but leave "Fordson" unchanged
Phil

On Nov 1, 4:48*pm, Dave <david_l... (AT) hotmail (DOT) com> wrote:
Instead of using
=[CarModel] & " " & [CarColour]
use something like
=FigureItOut([CarModel],[CarColor])
which calls the function FigureItOut. Then build the logic into your
function.