User manual
Table Of Contents
- Preface Learning how to use FileMakerPro
- Chapter 1 FileMaker Pro basics
- Chapter 2 Adding and viewing data
- Chapter 3 Finding and sorting information
- Finding records
- Finding text and characters
- Finding exact matches in text fields
- Finding numbers, dates, and times
- Finding ranges of information
- Finding data in related fields
- Finding records that match multiple criteria
- Finding empty or non-empty fields
- Finding duplicates
- Finding all records except those matching criteria
- Hiding records from a found set and viewing hidden records
- Viewing, repeating, or changing the last find
- Sorting records
- Finding records
- Chapter 4 Previewing and printing information
- Chapter 5 Creating a database
- Chapter 6 Creating and managing layouts and reports
- Chapter 7 Customizing layouts
- Chapter 8 Working with related files
- Chapter 9 Protecting databases with passwords and groups
- Chapter 10 Creating scripts to automate tasks
- About scripts
- Creating scripts: an overview
- About ScriptMaker steps
- Control script steps
- Navigation script steps
- Sort, find, and print script steps
- Editing script steps
- Fields script steps
- Records script steps
- Windows script steps
- Files script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
- Changing scripts
- Duplicating, renaming, or deleting scripts
- Importing scripts
- Listing scripts in the Scripts menu
- Using buttons with scripts
- Example of a ScriptMaker script
- Chapter 11 Using formulas and functions
- Chapter 12 Importing and exporting data
- Chapter 13 Sharing databases on a network
- Chapter 14 Publishing databases on the Web
- About publishing databases on the Web
- How users work with databases on the Web
- What you need to publish databasesontheWeb
- Publishing databases on the Web: an overview
- Enabling FileMaker Pro Web Companion
- Configuring FileMaker Pro WebCompanion
- Enabling Web Companion sharing
- Setting up browser views
- Testing your published database
- About browser views for web publishing
- Chapter 15 Using ODBC with FileMakerPro
- Appendix A Customizing FileMaker Pro
- Appendix B Backing up and recovering files
- Appendix C FileMaker Pro Quick Reference (Windows)
- Appendix D FileMaker Pro Quick Reference (Mac OS)
- Index
6-22
FileMaker Pro User’s Guide
1 In Layout mode, to set default field attributes from the attributes of
an existing field (for example, to specify that all new text fields you
place have text attributes that match an existing field or all new
number fields you place have number formats that match an existing
field), Ctrl-click (Window) or 2-click (Mac OS) the existing field.
Specifying text formats for fields
In Layout mode, you can specify a set of text character attributes for
each type of 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 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
menu > Text.
If no fields are selected or you’ve just placed a field and it’s still
selected, you will set text formats for that field and for fields you
place later.
2. In the Text Format dialog box, select options, then click OK.
For more complete information, see “Formatting text” on page 7-12.
Keep these points in mind:
1 You can also format text (not in a field) on a layout. See
“Formatting text” on page 7-12.
1 Use the Text Formatting toolbar (choose View menu > Toolbars >
Text Formatting) or context menus for quick access to many text
attributes. See “Using toolbars” on page 1-5 and “Using context
menus” on page 1-5.
Specifying formats for fields containing numbers
You can control how FileMaker Pro displays the values in number
fields, calculation fields with numeric results, summary fields, and
global fields defined as Number.
1. In Layout mode, select one or more fields that display numeric
values.
2. Choose Format menu > Number.
3. In the Number Format dialog box, select the formats you want to
use.
You see examples of the options you choose in the Sample area.
Choose text
attributes
Select one or
more styles
Define the symbols
for thousands and
decimal separators
Specify font, style, size, line
spacing, alignment, and color
Choose options
for Boolean or
decimal numbers
Set options
for negative
values