I am running a SWITCH query on an access table and then using this field in a report. The data returned needs to be broken into two lines. Is there a way to make the result set expressed in a two line format by using some sort of a line break...i.e. <br> but for Access. Here is my current query, the returned data would read on one line "mm/dd/yy (Actual)". I would like that to be broken into two lines without just using space characters b/c that offsets the center formatting.
Target or Actual: Switch([Actual Delivery Date Value]<>'',[Actual Delivery Date Value] & "(Actual)")