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
7-2
FileMaker Pro User’s Guide
5. Click OK.
Keep these points in mind:
1 The settings you choose in the Field Borders dialog box affect the
appearance of the field in all modes. If you just want to see field
boundaries in Layout mode to, for example, align fields, choose View
menu > Show > Field Boundaries. On the other hand, if you want to
see the effects of Field Border settings while in Layout mode, hide
Field Boundaries.
1 You can also change a field’s fill and border formats using the fill
and pen pop-up palettes in the status area. (You must have already
specified borders in the Field Borders dialog box.) Changes made in
the status area to the fill and pen settings replace settings in the Field
Borders dialog box, and vice versa. See “Setting color, pattern, line
width, and object effects” on page 7-14.
1 You can also specify an effect (Embossed, Engraved, or Drop
Shadow) for fields with the effect pop-up palette in the status area.
See “About object effects” on page 7-15.
Adding scroll bars to fields
Add a vertical scroll bar to a field to see more data than fits in the
field’s boundaries in Browse mode. (You can’t add scroll bars to
container, summary, or repeating fields, or fields formatted to use a
value list.)
1. In Layout mode, select one or more fields.
Or, to specify attributes for fields you add later, start with no fields
selected.
2. Choose Format menu > Field Format.
3. In the Field Format dialog box, for Style, select Standard field, then
click Include vertical scroll bar.
4. Click OK.
To Do this
Add borders to fields
and set their attributes
Select any combination of Top, Bottom, Left, or Right.
From the format list, choose Borders and choose a
color, pattern, and line width from the pop-up palettes.
Add text baselines and
set their attributes
Select Text baselines. From the format list, choose
Baselines, then choose a color, pattern, and line width
from the pop-up palettes.
Add a fill color,
pattern, or both to
fields
From the format list, choose Fill, then choose a color,
pattern, or both from the pop-up palettes. (The
checkboxes have no effect on fill attributes.)
Add borders between
repetitions in repeating
fields
Select Between repeating values. From the format list,
choose Borders, then choose a color, pattern, and
width from the pop-up palettes.
This option inserts lines between occurrences of
repeating fields. To also include borders around
repeating fields, select any combination of Top,
Bottom, Left, or Right.
Click to add a
vertical scroll bar