Assign a "*" to the end of the Surname if another field contains text
I have a school database that has some fields with information in, but they are not normally displayed, they reside on a tab the I have to click on to inspect. However, I would like an indication if the field concerned contains any text by adding a star/asterisk (*) to the end of the Surname in the main record. That way the user is alerted to the fact there is information on another tab. Suggestions of the most elegant way for doing this please.