User manual FILEMAKER FILEMAKER PRO 7

[. . . ] FileMaker Pro 7 User's Guide TM © 1995-2004 FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker is a trademark of FileMaker, Inc. , registered in the U. S. and other countries, and ScriptMaker and the file folder logo are trademarks of FileMaker, Inc. You are not authorized to make additional copies or distribute this documentation without written permission from FileMaker. [. . . ] You see examples of the options you choose in the Sample area. Choose options for Boolean or decimal numbers and currency Set options for displaying different Japanese numeral types Specifying text formats for fields In Layout mode, you can specify a set of text character attributes for each field. All the characters in that instance of the field (including all repetitions of repeating fields) share the same font, size, style, color, line spacing, tab, and paragraph settings. Note You can also format characters in text fields in Browse mode (for example, italicize or underline a word for emphasis). Unlike text formatting specified in Layout mode, this formatting is stored with the data, and you see it in any layout that displays that field. 1. In Layout mode, select one or more fields, then choose Format Set options for negative values menu > Text. Or, to set text formats for fields you place later, start with no fields selected. 2. Click OK. Define the symbols for thousands, decimal, and Kanji separators Specify font, style, size, line spacing, alignment, and color You see examples of the options you choose in the Sample area. Creating databases 57 Specifying formats for date fields You can control how FileMaker Pro displays the values in date fields, and calculation fields with date results. Note To avoid confusion when using dates in fields, FileMaker recommends that you always format date fields to display four-digit years. 1. In Layout mode, select one or more date fields or calculation fields Specifying formats for time fields You can control how FileMaker Pro displays time values in fields. 1. In Layout mode, select one or more time fields, or calculation fields with a time result. 2. In the Time Format dialog box, select the formats you want to use. with a date result. 2. In the Date Format dialog box, select the formats you want to use. You see examples of the options you choose in the Sample area. 4. Click OK. You see examples of the options you choose in the Sample area. If you want to format the seconds component to display fractional seconds, continue with the next step. 5. In the Number Format dialog box, select the formats you want to use. Choose to display numbers either as entered, in a predetermined format, or in a format you specify Choose options for day, month, date, year, and separator characters Only two options affect the display of the seconds component: Fixed number of decimal digits and Decimal separator. Click OK. Choose options for displaying Japanese dates Choose to display times either as entered, in a predetermined format, or in a format you specify Set font, style, size, color, line spacing, and alignment Choose options for displaying Japanese times 4. Click OK. Set font, style, size, color, line spacing, and alignment 8. Click OK. 58 FileMaker Pro User's Guide Specifying formats for timestamp fields You can control how FileMaker Pro displays timestamp values in fields. You format a timestamp field by separately formatting its three components: date, time (excluding the seconds portion), and seconds (including fractional seconds). 1. In Layout mode, select one or more timestamp fields, or You see examples of the options you choose in the Sample area. File icons do not scale. Choose how to fit the graphic in the frame Choose how to align the graphic horizontally Choose how to align the graphic vertically calculation fields with a timestamp result. 2. In the Date Format dialog box, select the formats you want to use and click OK. 4. To format the time component (except the seconds portion), choose Format menu > Time. 5. [. . . ] See Relational databases Date fields described 40 entering and editing values in 22 four-digit years 22, 46 Dates See also Date fields entering data 22 finding 26 finding today's 26 formatting 57 four-digit years, verifying 46 invalid 26 typing in 22 validating 46 dBASE file format 76 DBF format 76 Decimal numbers 56 Defining See also Adding; Placing accounts 86 calculation fields 41 databases 39 fields 39 lookups 71 passwords 85 privilege sets 88 summary fields 43 tables 47 Deleting data 22 fields from a layout 55 find requests 29 related records 21, 70 Designing databases planning 35 relational 35 Dictionary files, preserving during file conversion 96 DIF format 76 Document preferences 34 Drag and drop, fields onto layout 54 Duplicate records, finding 27 Duplicating files 16 records 20 related records 20 E Electronic documentation 7 Elements. See Objects Index 101 Empty or non-empty fields 27 Encryption. See Accounts; Privilege sets Entering data automatically 45 Furigana 41 typing in fields 22 Envelope layout See also Layouts described 51 Excel format 76 Exchanging files exporting 76, 78 importing 76 relational databases 61 with other applications 76 Exporting See also Exchanging files described 76 file formats 76 formatting 78 Extended columnar layout. See Columnar list/ report layout Extended privileges described 82 viewing 89 External Server account 82, 88 F False result 26, 40, 46, 56, 97 Field behavior 59 Field definitions copying 16 creating 39 Field labels 55 Field names 39 Field rights. [. . . ]