I have an unbound field in which I have concatenated five field: first name, surname and three address lines. Is there anyway to specify that the surname should print in capitals when it is not set-up this way in the underlying table?

Try adding the surname field to the report and set the format property to ">" and the visible property to no.