I have a Browse screen that lists peoples names. I also have an Edit Screen that lists all their details (address, DOB etc). I would like to have an indicator so that I can know on the Browse screen whether the information is incomplete. I have tried doing a series of tests with an IF statement to check if anything is not filled in and writing a
IF(ThisItem.Address = "" Or ThisItem.Suburb = "" Or ThisItem.DOB = "",ThisItem.Fname & " !",ThisItem.Fname)
which is supposed to put a ! at the end of the Surname, but it's not working. I am putting this function in the text section of FName. Any help would be much appreciated.