Richard

Your data must be coming from somewhere, I assume a table.

I also assume you built your report directly on the table.

My recommendation was to first create a query that returns the data you wish
to have in your report, then base the report on that query.

In your query, you could use the IIF() function to test for "M McManus",
generating a True/False. Then, in your report, use the True/False to set
the visible property of the control.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"richard" wrote in message
...
sorry Jeff

I have no idea how to go about what you are suggesting.

Richard

"Jeff Boyce" wrote:

No, that wasn't what I was suggesting. In the code you were comparing to
a
string. Why not do that comparison in a query before getting to the
report?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"richard" wrote in message
...
Jeff

If I understand you right would this be as follows

Have the signatures stored as objects in a table??? (the signatures are
a
JPEG file stored on the server. Not sure how to do this but will go
away
and
have a look) and then pull this object into the query based upon
criteria
for
the Analysts Name. This field can then be put into the report straight
from
the query.


Thanks

Richard
"Jeff Boyce" wrote:

Richard

Another approach might be to do the comparison in a query underlying
your
report.

Regards

Jeff Boyce
Microsoft Office/Access MVP