User manual

22 FileMaker Pro User’s Guide
Entering and changing data in fields
You can enter or import data up to the character limit for the field
type. You can view and print only the data that fits within the field
boundaries.
To Click in the field in Browse mode, then
Enter data in a text field Type the text (up to 1 billion characters).
Enter data in a number field Type the values (from 10
400
to 10
-400
).
Enter data in a date field Type one date on one line in the field. Type the
day, month, and year as numbers (for
example, 3/3/2005), separated by a
nonnumeric character like – (minus) or /
(forward slash).
Note You cannot use a : (colon) as a date
separator.
Important If you enter dates with two-digit
years, FileMaker Pro converts them to four-
digit year dates using a conversion method
described in Help. To avoid misinterpretations
during conversion, always enter dates with
four-digit years.
Enter the current date in a date,
number, or text field
Choose Insert menu > Current Date.
Enter data in a time field Type the time of day (or time duration) as:
1 hours
1 hours and minutes
1 hours, minutes, and seconds
1 hours, minutes, seconds, and fractional
seconds
Separate hours, minutes, and seconds by a
nonnumeric character like : (colon).
Separate fractional seconds by a . (period).
Type the time of day in 24- or 12-hour format,
with or without AM or PM. (AM is assumed
for a time less than 12:00.)
Enter the current time in a time,
number, or text field
Choose Insert menu > Current Time.
Enter data in a timestamp field Type the date and time (for example,
10/15/2005 3:15:05 PM). Type the day,
month, and four-digit year as numbers,
separated by a nonnumeric character like -
(minus) or / (forward slash).
Note You cannot use a : (colon) as a date
separator.
Then type the time of day as:
1 hours and minutes
1 hours, minutes, and seconds
1 hours, minutes, seconds, and fractional
seconds
1 Type AM or PM if the time is not in 24-
hour format
Separate hours, minutes, and seconds by a
nonnumeric character like : (colon).
Enter the current date and time
in a timestamp field
Choose Insert menu > Current Time.
Insert a tab character in a field Click where you want to insert the tab. Press
Ctrl+Tab (Windows) or Option-Tab
(Mac OS).
Delete data from a field. Select the data, then press Backspace or
Delete.
Add data to a container field For information, see Help.
Insert a file in a container field For information, see Help.
Add data to value lists (fields
formatted as radio or option
buttons, checkboxes, lists, or
menus)
For information, see Help.
Edit, format, or check the
spelling of text in a field or edit
dictionaries
For information, see Help.
To Click in the field in Browse mode, then