March 5, 200718 yr Hello, I am trying to find a way to add a checkmark next to a field if that field is not empty, any suggestions on how??? Thank you, Tom
March 5, 200718 yr Let's say your field is called FieldName. 1. Add a calc field FieldFull_flag= if (not isempty(FieldName, 1, 0). Make sure in the Storage tab that you have Do Not Store selected. 2. Create a Value List, "1/0" that contains the values 1 and carriage return and 0. 3. Place the calc field on your layout and format it to be a checkbox, and resize it to only show the first checkbox. 4. Assign the "1/0" value list to your checkbox. 5. Turn off Browse Mode in the Field Behavior for the checkbox.
March 6, 200718 yr It might be a little overkill to define a VL, when you can define a numeric fields appearance as boolean - here can the result of a simple IsEmpty(fieldName)'s positive result be given void and the negative be given unicode 2713 or something in that direction. --sd
Create an account or sign in to comment