August 2, 200421 yr I have a number of fields which are not always filled in and I have noticed my display looks a bit alcking when they haven't been filled in. What would be the best way to have empty fields entered as showing "Not filed in" Thanks
August 2, 200421 yr There are probably a few ways to approach this. One option is to create a calculated field corresponding to each entry field. Something like: Case( IsEmpty( entryField1 ), "Not filled in" ) Put the calc field behind the corresponding entry field, and set it to not allow entry. Make your entry field transparent and there you have it.
Create an account or sign in to comment