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
3-64 FileMaker Pro User’s Guide
Formatting date values in individual fields
Format dates in date fields, or calculation, summary, or global fields that
have a date result. You can also leave a date unformatted, so it will
display and print as typed. A date field can hold values from
1 January 0001 to 31 December 3000.
1. In Layout mode, select a date field, and then choose Date from the
Format menu.
To format more than one date field at a time, Shift-click each field to
format, and then choose Date from the Format menu.
2. In the Date Format dialog box, select options, and then click OK.
Display of zero values Select Do not display number if zero.
Decimal separator For Decimal separator, double-click the current default, and then
type a new one.
Thousands separator Select Use thousands separator, double-click the current default,
and then type a new one.
Format for negative
numbers
For Format as, choose an option. To display negative numbers in
color, select Use color, and then choose a color.
Choose FileMaker Help Index from the or Help menu, and then type:
E numbers, formatting
To display dates Do this
Exactly as typed or
entered
Click Leave data formatted as entered.
In a particular format Click Format as, and then choose a format. To change the
default separator between parts of numeric dates, for Numeric
separator, type another character.
In a custom format Click Custom, and then choose options and separator characters
for day of week, month, date of month, and year.
With leading zeroes (as
in 01/02/98) or leading
spaces in numeric parts
of dates
Choose options for For day numbers, For month numbers, or both.
With different text
attributes
Click Text Format, and then select options. (See “Formatting
text attributes in individual fields” on page 3-60.)
To change the
default Do this