Valuelist/Checkbox question

[Ladys]

Hello,

here is my problem:

I am building database of our employees. Each record (person) has also checkbox field based on Value List, where I select some status (Contract signed, Can use company cars... etc.).

Then I would like to be able to easy check status off all employees.

So I created layout, one line = one person. What I would like to do, is to have all checkboxes for that person in one line. That's possible to do, but i don't want there the checkboxes value to be shown. I just would like to have only the checkboxes, not the text.

I know, I can create some calculation, but the problem is, that value list is changing sometime by Edit displayed in Value list, and I don't want to edit all that calculated feelds every tim.

Is there a solution how to do it?

[LaRetta]

Hmmmm, if I understand, you want the checkbox itself without the label. You can resize the checkbox (if the list is vertical) to only wide enough to show the checkbox itself. But that will not work if you want the checkboxes horizontally (because the labels will show). If you want horizontally (or want to manually space the checkboxes) then create one value list for EACH selected value ... hold on, it'll make sense here soon...

Then take your checkbox field. Set the width of the field to same as the field height (you only want one checkbox to show and no labels). Change the attached value list to the first newly created value list. Duplicate the field and change the attached value list on IT to the second newly created value list (the one with the second value) and so on. Since these checkboxes are attached to the same FIELD, they will still act as a set. But since they use DIFFERENT value lists, they will only appear 'checked' if the field contains a matching entry to its single-entry value list. By handling checkboxes in this manner, you can precisely place checkboxes all over your form if you wish and they will still respond in unison. I learned this nifty trick from CobaltSky back on vs. 6.

LaRetta