Jump to content
Sign in to follow this  
ep820

Checkbox "views"

Recommended Posts

On my data entry screen I have 6 checkboxes. On my report form, I want to print out only the name of what items were checked off. My problem is the report form field lists the items checked ina column, and I need it to print out in a row in order to save space. Just dragging & shaping the field to one long row does not work, it only shows the first choice and the rest are out of sight below it, all space to the right of that first chice is blank.

Share this post


Link to post
Share on other sites

Using the simple Subtitute() will put the values in order that they were clicked. Don Wieland's technique is more complicated, but the values are sorted.

Share this post


Link to post
Share on other sites

Make a value list based on the checkbox through a self-relationship of serial. Then make your unstored text calculation Substitute( ValueListItems( Status(CurrentFileName), "checkboxvaluelist" ), "

Share this post


Link to post
Share on other sites

Hi JT,

Don's solution doesn't use this approach, it uses a very long calculation, and a second field. I like your solution a lot better except it is slow updating the "one line field". Anyway to speed this up, or do you have to click into field, or change records to another record and then back.

Lee cool.gif

Share this post


Link to post
Share on other sites

Thanx MoonShadow, I tried your suggestions first and it worked like a charm!! and thanks to the rest of you too, I'll file away those ideas when I start to use more complex lists.

Share this post


Link to post
Share on other sites

Hi Lee. Unfortunately, a manual or scripted screen refresh is always necessary when using ValueListItems calculation fields. This is the only major drawback to using them. In version 7 though, you could use script parameters to set the checkbox field and refresh the calculation.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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