Jump to content

This topic is 7487 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.