I've followed these instructions carefully,
but it's not working, alas.
Ah, it occurs to me, (finally) could it be because the field in
question is a global field?
Mary E. MacNeil
Database Manager
University of Virginia Press
P.O. Box 400318
Charlottesville VA 22904-4318
FAX: 434.982.2655
VOX: 434.243-2367
[EMAIL PROTECTED]
Beverly Voth wrote:
On 11/13/08 2:41 PM, "Mary E. MacNeil" <[EMAIL PROTECTED]> wrote in whole
or in part:
How can I make a checkbox control display
all boxes checked as the default? Currently
has one checked by default, but I can't see where
that is being set.
Mary, the field is only "formatted" as checkbox on the layout. If you place
the same field (not formatted) on the layout, you'll see that the
information is "return-delimited". Everything that is "checked" will be in
the unformatted field, the other items are not.
To make the field "default" is to set it up in the Define Fields dialog.
Because this field has many values (with a return between each of them), I'd
go to the original definition for the value list, copy the values. Then go
to the define fields option for the field and "auto-enter" by calculation.
The calculation will be the "literal" values you copied. That means you need
to put them in quotes and signify the return character "¶" (Pilcrow) where
needed.
So a value list with:
Red
Green
Blue
Will be pasted into the define fields option for auto-enter calculation as:
"Red¶Green¶Blue"
Close dialog box and from then on the field will have these values CHECKED
when a new record is created.
An interesting aside: the ORDER in which checkboxes are "checked" will
determine the order of the values in the field (unformatted). Try it!
HTH,
