Originally Posted by
Ajax
to split the highlighting you would need to use richtext something like
Expr1: "<div><strong>" & [first_name] & "</strong> <font style=""BACKGROUND-COLOR:#FFFF00"">" & [last_name] & "</font></div>"
and in the query properties for that column set the text format property to rich text. Note this property can disappear once you have run the query for the first time so do this by creating a new column
However better to do this in a form, it will be more stable and users should not be looking at queries directly