View Single Post
  #1  
Old May 25th, 2010, 07:01 PM posted to microsoft.public.access.reports
mark kubicki
external usenet poster
 
Posts: 84
Default simple textbox data source syntax question

Would someone please take a look over my shoulder? I've got the following
code entered as the data source for a text box on a report; but even in it's
simplest state, returns #error#

the intent of the code is to truncate the text at it's first hard return

=mid([CatalogNoMod],1,nz(instr(1,[CatalogNoMod],chr(10)),len([CatalogNoMod])))


any thought would be greatly appreciated in advance
thanks,
mark