U.M. (Windows)
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
- Appendix D: Linking and embedding objects
- Index
- Quick Reference
3-58 FileMaker Pro User’s Guide
Defining display formats for fields
Display formats make data in fields look consistent when the data is
displayed or printed. The formats don’t change the data as stored in the
file. For example, a number field can be formatted to display three
decimal places. You can do the following:
1 Set no formats in FileMaker Pro. When you set no formats,
FileMaker Pro displays numbers, dates, and times according to the
operating system settings that were in effect at the time the file was
created. (See appendix B, “Working with international files” and the
documentation that came with your computer or your copy of Windows.)
1 Set default display formats in FileMaker Pro for all text, number,
date, time, and container fields you plan to define (see “Setting
default display formats,” below).
1 Define data formats individually in FileMaker Pro for existing text,
number, date, time, and container fields (see the sections beginning
on page 3-59).
On a field by field basis, each layout can have a different set of formats.
For example, suppose you format number fields to display a currency
symbol, thousands separators, and two decimal places. If the currency
symbol is a dollar sign ($), the thousands separator is a comma (,), and
the decimal separator is a period (.), the value 5000 displays as
$5,000.00. However, only the value 5000 is stored in the file.
Setting default display formats
Set default display formats for newly created fields. Default formats set
in FileMaker Pro override formats set in the Regional Settings control
panel and affect only FileMaker Pro files. Default formats apply to
newly defined fields added to the current and new layouts.
1. With no fields selected in Layout mode, choose Text, Number, Date,
Time, or Graphic from the Format menu.
2. In the Default Format dialog box, select options, and then click OK.
You can also set a default display format if you have just added a new
field to a layout.
Choose FileMaker Help Index from the Help menu, and then type:
E formatting fields
?