SEARCH function

  • Thread starter Thread starter Sullivan
  • Start date Start date
S

Sullivan

As part of one of the text boxes in a report, I need to
only use part of a field. So, I was going to use Mid
(Stringname,Search(" ",Stringname),10) to get the
substring of stringname I need. However, The report seems
to not like the function Search. It always comes up with
an input box when I go to open the report in print view,
rather than design view. Can someone PLEASE help
me?!???!!??!! I have no idea why this won't work!
 
Sometimes reports are funny with functions. Instead of
doing th function in the report base the report on a query
and add a new field with the function in it.

Jim
 
Back
Top