1299
Index
filtering
dialog boxes, 700
by form, 246
forms, 699–700
new features, 1259–1261
records, 242–246
filtering data in forms
with code, 888–889
interactive filter dialog boxes, 892–894
With keyword, 895
linking dialog boxes, 894
with queries, 889–895
wildcards, 890–891
filtering forms
enabling, 310
specifying records for, 309
at startup, 309
filtering selections, 475. See also WHERE clauses.
Find and Replace dialog box, 228–230
Find group
Datasheet ribbon, 220
Form ribbon, 293
finding
case sensitivity, 229
data in code, absolute speed, 865–866
fields, 229–230
and replacing records, 220, 228–230
specific values, 228–229
finding data in forms
bookmarks, 885–888
FindRecord method, 883–885
unbound combo boxes, 881–883
FindNext method, absolute speed, 865–866
FindRecord method, 865–866, 883–885
FindWindow API, 775
First option, 657
first/last field values, finding, 657
Fixed format, 61
fixed-width files, importing, 621–623
fixed-width text files, linking to, 596–597
flat-file databases, 95–97, 104–105. See also spreadsheets.
focus events, 452
fonts
modifying, 239
Query Design Font option, 650
screen versus printer, 308
footers, forms, 311–312
For Each function, absolute speed, 864
For Each statements, 409–410rearranging, 235–236
renaming, 41, 57, 647–649
resizing, 57, 143–144
sequence of, 46
size, specifying, 49
updating with data macros, 561
values, definition, 8
fields (columns), displaying
field display width, modifying, 237
rearranging fields, 235–236
resizing field width, 237
fields (columns), properties
AllowZeroLength, 60
assigning, 58–59
Caption, 59
DecimalPlaces, 59
DefaultValue, 59
FieldSize, 59
Format, 59, 60–61
IMEMode, 60
IMESentence Mode, 60
Indexed, 60
Input Mask, 59
New Values, 59
Required, 60
setting, 45
SmartTags, 60
UnicodeCompression, 60
Validation Rule, 60
Validation Text, 60
Fields ribbon tab, 43
FieldSize property, 59
File button, 27–28
File dialog box, new features, 1255
File DSN, 1204
file formats supported, 844. See also specific formats.
file location, network applications, 753–754
File menu, 27–28
file system information, getting, 958–959
File tab, new features, 1254
file types, databases, 5
files, on the CD-ROM, 1267–1270
Filter by Form button, 246
Filter By Group option, 35–36
Filter event, 458–459, 700
Filter Name argument, 1060
Filter On Load property, 309, 653
Filter property, 309, 65252_475348-bindex.indd 129952_475348-bindex.indd 1299 4/1/10 2:02 PM4/1/10 2:02 PM