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
Customizing layouts
7-3
Keep these points in mind:
1 Scroll bars are always displayed if you set the field borders option
for the right side of the field. Otherwise, they display only when you
tab into the field. See “Adding borders, fill, and baselines to fields”
on page 7-1.
1 When you print a field or a portal with a scroll bar, FileMaker Pro
prints only the data visible without scrolling. To print all the data,
duplicate the layout and enlarge the field or portal, then specify
sliding options to remove the extra blank space when you print. See
“About removing blank space from printed data” on page 7-22.
Defining a list of values for data entry
If a field uses the same set of values for many or all records, you can
have users choose values from a value list. A value list lets you
define frequently used text, number, date, or time values and then
format the field to display the values in a pop-up menu, a pop-up list,
or as series of checkboxes or radio buttons. This provides a fast,
accurate way to enter or validate data in fields.
You can define a value list in a number of ways. The most general,
least restrictive way is to define the value list first and then assign it
to one or more fields. You can also define the value list when you’re
specifying formatting options in Layout mode.
To define a value list:
1. Choose File menu > Define Value Lists.
2. In the Define Value Lists dialog box, click New.
3. In the Edit Value List dialog box, for Value List Name, type a name.
Choose from a list of
values during data entry
Value list attached to the Category field
Click to sort by
a heading or
drag column
boundaries
Value lists
defined in
the file
Drag to resize dialog box
Type a name for
the value list
Choose a method to
create the values
for the value list