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,
--
Beverly Voth Tier3 Data & Web Services Group, LLC
606-864-0041 http://www.tier3web.com/xml.htm
Web Design & Hosting * Apple: CAN, ACN & ADC
Certified FileMaker 7 & 9 Developer * FileMaker Business Alliance
Coldfusion, Witango, PHP, MS SQL, MySQL, FMP, XML/XSLT, CSS
Over 14 years experience integrating databases and the internet!
