Has anyone noticed that clicking a checkbox in IWP adds a carriage return to the end of the value? Any way to make this stop doing this?

Isn't this normal behavior for checkboxes in general (not just with IWP)?

If you look at the results of a field formatted as an edit box after data has been entered by checkboxes you will find that multiple values are delimited by carriage returns. If you suppress that behavior the checkboxes won't work.

I'm with Matthew here, a way to use the value later sans these is simply to trim them off via:

http://www.filemaker.com/help/FunctionsRef-355.html

...but you face another problem, the checking could be entered arbitrarily, so plucking the first not nessersarily is the first box checked seen from the layout.

Such a checkbox field can be sorted via autoenter(update) and this calc:

FilterValues(ValuelistItems(Get(FileName);"theList";_yourField))

Maybe this template will make these aspects more clear?

--sd

Untitled.zip

Sorry I should have been more clear. This is just a boolean checkbox (check the box for "1", uncheck for off). I don't like to use radio boxes in this situation because of the need to hold down shift to deselect.

In the client it just puts the "1" in the field, in IWP it adds a carriage return.

Perhaps you should explain why it's a problem in your context, getting rid of it is pretty easy:

Left(_yourField;1) or

Filter(_yourField;"1")

Abs(_yourField)

Int(_yourField)

...just to mention a few...

--sd

Yeah I used the left function. It just irritated me that I had to. Just wondering if anyone knew why it behaved differently than the client and if there was a way to fix it instead of workaround it.

Could this observation be substantiated, this is normal checkbox behavior in my humble opinion ...mfero seems to agree with me?

--sd