[X]My Assistant

[hankfromca]

Hi There, I am not really sure of the best way to do this, but I have a report that is displaying unwanted data in a field. The field on the report is

[color2]

it is displaying a value of #Func! on the report.

I just want it so that anytime #Func! appears it does not display anything. The field [color2] is controlled in query with the following:

Color2: Left([Color1],InStr([Color1]," ")-1)

I believe that the data in question does not have a value for this for this field so I think it is generating the result of #func!... I am not sure where to control it so nothing displays when there is no data for the field. I thought maybe address it in the report as the expression is complicated for me, but I have no idea.

Any ideas on the best way to approach this is greatly appreciated. Thanks so much. Hank

[cheekybuddha]

There might be a better way to do this, but a quick solution might be:

CODE

Color2: IIf(InStr(Nz([Color1], "")," "), Left([Color1],InStr([Color1]," ")-1), "")

hth,

d

[hankfromca]

Hi David Marten, That works just perfectly... Thank You.. Hank

[cheekybuddha]

Hank,