checkboxes limited to 3 values?

Classic Servoy
1

I searched the fourm for the answer, so forgive me if this has been addressed.

I have a custom valuelist displayed on a form with about 10 different values. The values are stored in a field and the display type is CHECK, but I am limited to selecting only 3 values at a time.

Is there a way around this?

thanks
Bill

2

I guess this is because the return value of the check box is the text caption, and the field length in the underlying database table is limited

So either use numbers (PK) as return value or extend the length of the attached field.

3

How big is your field? Maybe the field is simply too small to hold more than 3 checked items?

4

Hi Bill

The column in your database is limiting how many values you can have based on its size

Alter the column to be able to contain the maximum number of characters

Cheers
Harry

5

thanks everyone! duh. moving on. :)

6

actually one more question in regards to this.

can I control which of the checkboxes (which correspond to a value from my valuelist) are turned “on” by default?

If the value list connected to field colorName contains

Orange
Blue
Red
Yellow

I’m sure I can set the auto enter value to Orange and have that checked by default when a new record is created, but I’m not sure how I would do Orange and Yellow by default.

7

If I correctly understood your question, you can set value as text followed by \n

mycheckbox = "Value2\nValue15\n"
8

thanks MSibai.