simoncpage Posted August 2, 2004 Posted August 2, 2004 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
Fitch Posted August 2, 2004 Posted August 2, 2004 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.
Recommended Posts
This topic is 7487 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now