I have a query which I use as a recordset for a report. In this report, there is a text field where the report needs to return only the items on the first line (ie. everything left of the first carriage return). I had created a field using x:= Left([fieldname],InStr(1,[fieldname]," "
) as a temporary fix and told the user to add a double space at the end of the first line for each record (there were only a few). This works, but I would like to use something on the order of x:= Left([fieldname],InStr(1,[fieldname],vbcr)), but I do not know how to refer to vbobjects in a query. I expect that there is a better way to do this in a function, but the process eludes me. Thanks in advance for any help. Jim
) as a temporary fix and told the user to add a double space at the end of the first line for each record (there were only a few). This works, but I would like to use something on the order of x:= Left([fieldname],InStr(1,[fieldname],vbcr)), but I do not know how to refer to vbobjects in a query. I expect that there is a better way to do this in a function, but the process eludes me. Thanks in advance for any help. Jim