U.M. (Mac OS)
Table Of Contents
- Preface: Getting help
- Chapter 1: FileMakerPro basics
- Chapter 2: Creating a database file
- Chapter 3: Laying out and arranging information
- Understanding layouts
- _
- Working with predefined layout types
- Arranging records in columns
- Managing layouts
- Working with layout parts
- Changing layout parts
- Working with all object types
- Working with graphic objects
- Working with fields in a layout
- Adding fields to a layout
- Adding merge fields
- Deleting a field from a layout
- Defining display formats for fields
- Determining data entry in fields
- Setting the tab order for data entry
- Adding scroll bars to fields
- Formatting repeating fields
- Adding borders, fill, and baselines to fields
- Defining value lists
- Formatting fields with value lists
- Working with text
- Chapter 4: Working with information in records
- Working in Browse mode
- Adding data to a file
- Selecting a field for data entry
- Adding and duplicating records
- Entering and changing data in fields
- Working with container fields
- Entering data from a value list
- Viewing and inserting data from another source
- Copying and moving values and records
- Using drag and drop to move information
- Replacing field values
- Working with records
- _
- Finding information
- Deleting records
- Sorting records
- Chapter 5: Using ScriptMaker and buttons
- Chapter 6: Previewing and printing information
- Chapter 7: Networking and access privileges
- Chapter 8: Importing and exporting data
- Chapter 9: Customizing FileMakerPro
- Chapter 10: Using data from related files
- Chapter 11: Publishing files on the Web
- About the World Wide Web
- About FileMaker Pro Web Companion
- Publishing your database on the Web—an overview
- Getting ready to publish your files on the Web
- Setting up FileMaker Pro Web Companion
- Configuring FileMaker Pro Web Companion
- Setting up Instant Web Publishing
- Database security
- Helping Web users find your database
- Custom Web Publishing
- Appendix A: Recovering damaged files
- Appendix B: Working with international files
- Appendix C: Summary of functions
- Index
Laying out and arranging information 3-63
Keep these points in mind:
1 Numbers with decimal digits that exceed the specified number are
rounded. If you specify 0, no decimal digits are displayed. If you
specify a negative value, numbers are rounded to the number of
positions left of the decimal separator. (For example, for the field
value 789.78, 2 fixed decimal places displays 789.78; 0 fixed places
displays 790; and –2 fixed places displays 800.) For calculations and
summaries, FileMaker Pro uses the original, unrounded, number.
1 Only numbers are displayed and printed in a number field formatted
as Boolean or decimal (except for symbols set in the Number Format
dialog box). To display text and symbols (as in @1.98 per pound) in a
number field, don’t define a number format.
1 When you work with a file created with different system formats and
you want to use the formats set on your computer, choose Use System
Formats from the Format menu. See appendix B, “Working with
international files.”
Changing options for numerical data
You can change the default symbols used as the thousands separator and
decimal separator. Unless you changed them previously, the default
settings are taken from the Numbers control panel. You can also change
the default format for negative numbers.
1. In Layout mode, select a number field, and then choose Number from
the Format menu.
2. In the Number Format dialog box, click Format as decimal, select
options, and then click OK.
Choose FileMaker Help Index from the or Help menu, and then type:
E numbers, formatting
To change the
default Do this
Number of decimal
digits
Select Fixed number of decimal digits, and type a new value.
Notation symbol and
position
Select Use notation, and then choose Percent (to display a percent
symbol after the value, Currency (leading) (to display a currency
symbol before the value) or Currency (trailing) (to display a
currency symbol after the value.)
Currency symbol For Currency symbol, select the current default, and type a new
one.
?