checkmark result

[tommypmadison]

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

[bcooney]

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.

[tommypmadison]

Thanks!

Just tried it and it works perfect!

Thanks,

Tom

[Søren Dyhr]

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

[mr_vodka]

Here is a link to Comment's Solution for displaying booleans and checkboxes.