1280
Index
color coding
breakpoints, 539
comments, 419–420
identifiers, 419–420
keywords, 419–420
syntax errors, 526
Column Headings property, 653
columnar reports, 321–322
columns (database). See fields.
columns (report)
layout, specifying, 745
number of, specifying, 745
snaking, 741–747
spacing, specifying, 745
vertical lines between, 729–730
combo boxes. See also controls; list boxes.
absolute speed, 861
creating, 74–76
displaying reports, 739–740
forms, 691–693
selecting items from lists, 299–300
synchronizing list contents, 682
unbound forms, network applications, 785
comma (,)
field separator, 620
thousands separator, 62, 67
Command Button Wizard, 385–386
command line, getting, 952–953
Command object, 492–494
command-line arguments, 414–415
Command-Line Arguments option, 414–415
commands
Alternate Fill/Back Color, 220
Blank Form, 252
Datasheet, 253
Decrease Horizontal, 277
Decrease Vertical, 277
Equal Horizontal, 277
Equal Vertical, 277
Form, 252, 253–254
Form Design, 252
Form Wizard, 252, 254–257
Format Painter, 292–293
Group, 278–279
Increase Horizontal, 277
Increase Vertical, 277
menu display, customizing, 1091
Modal Dialog, 253
More Forms, 252closing
forms, 469–470, 691
ribbons, 1045–1046
clustered indexes, 1189
CmdBeforeExecute event, 464
CmdEnabled event, 464
CmdExecute event, 464
code
looping through, 404–406
storing, 851–853
code editors. See VBA editor.
code window
editing VBA modules, 393
ribbon, 393
splitting, 393
toolbar, 393
collapsing
macro items, 573–574
the ribbon, 1011
submacros, 1059
collection items, VBA
counting, 407
looping through, 408–410
naming conventions, 407
number of, effects on performance, 408
referencing, 407
collections, Access
definition, 486
naming conventions, 486
collections, VBA
Count property, 407
counting items in, 407
definition, 406
Item property, 407
looping through, 408–410
Name property, 407
naming conventions, 407
properties of, 407
colon (:)
compiler argument separator, 414
date/time separator, 67
time element separator, 63
color
background, modifying, 239–241
control background/foreground, 682
formatting output, 61
highlighting alternate records, 220, 239–241
in reports, 331–335, 368–369
specifying, 6152_475348-bindex.indd 128052_475348-bindex.indd 1280 4/1/10 2:01 PM4/1/10 2:01 PM