January 16, 200917 yr Hello. Two FM9 questions here: 1) I want a couple of fields to default to title capitalization, yet to be able to override this default on a per-record basis. That is, usually have text formatted by title capitalization, except to be able to change it when inappropriate--such as when Roman numerals are used: Henry VIII not Henry Viii It seems that I can only toggle the control in the Text.. dialog on a database-wide basis. 2) Is there a way to change the appearance of checkboxes--specifically, to make them larger?
January 16, 200917 yr You may need 2 fields: one for data entry, and the other an auto-entered calc: Proper(entryField). You can then modify the 2nd field when needed. Not ideal, but maybe workable. If I understand your 2nd question it's simple: use a larger font size. You can also specify a different line thickness.
January 17, 200917 yr ...such as when Roman numerals are used: Henry VIII not Henry Viii You can try something like this calculation: Substitute ( Proper ( Substitute ( text ; [ "I" ; "1§1" ] ; [ "V" ; "5§5" ] ; [ "X" ; "10§10" ] ; [ "L" ; "50§50" ] ; [ "C" ; "100§100" ] ) ) ; [ "100§100" ; "C" ] ; [ "50§50" ; "L" ] ; [ "10§10" ; "X" ] ; [ "5§5" ; "V" ] ; [ "1§1" ; "I" ] ) User must enter text in lower case but Roman numerals in upper case.
January 18, 200917 yr Author Unfortunately, Roman numerals were only an example--there are other things I need to override capitalization for, also; I'd need a method that wasn't so specific. The only way to make a bigger checkbox is to use a bigger accompanying font??? That then makes the text much too big.
January 18, 200917 yr Unfortunately, Roman numerals were only an example. So, which are the rules ? The only way to make a bigger checkbox is to use a bigger accompanying font??? No, you can design your own chek box
January 20, 200917 yr Author If the only way to do it is a calculation based on predefined rules, I'm probably stuck: there are no rules. The field contains names, which don't necessarily have capitalization rules. It could be John AW or Bell-Howell (in FM's Title Capitalization system, Howell gets forced into lowercase).
Create an account or sign in to comment