1300
Index
Form view
Clipboard group, 292
creating forms, 290
enabling, 306
Home ribbon tab, 291–293
illustration, 290
navigating among fields, 294. See also Navigation forms.
navigating among records, 294
overview, 289–291
scrolling, 291
switching to, 290, 291
Views group, 291–292
Form Wizard command, 252, 254–257
Format event, 462–463
format painter, 696–697
Format Painter command, 292–293
Format properties, 59, 60–61, 283
formatting. See also reports, formatting.
, (comma), thousands separator, 62. (period), decimal points, 62
$ (dollar sign), formatting currency fields, 62
% (percent sign), formatting percentages, 62
(pound sign), hyperlink indicator, 65–66
(pound sign), placeholder, 62
0 (zero), placeholder, 62
Address property, 66
AllowZeroLength property, 70–71
AutoIndex option, 72–73
color, 61
control captions, 68–69
controls, 462–463
currency fields, 61
Currency format, 61
decimal places, 62
Display Text property, 66
E+, formatting scientific notation, 62
e+, formatting scientific notation, 62
E-, formatting scientific notation, 62
e-, formatting scientific notation, 62
Euro format, 61
Fixed format, 61
form properties for, 306–309
General Number format, 61
Indexed property, 72–73
indexing by table fields, 72–73
input, 69–70
Kanji conversions, 60
numeric fields, 61–62
Percent format, 61
Force New Page property, 366–367
ForEachRecord action, 560
ForeColor property, 682
foreign keys. See also primary keys.
definition, 20–21
matching primary keys, 114
Form command, 252, 253–254
form controls
naming conventions, 285–286
unsupported, 1175
Form Design command, 252
Form Designer, 38
form errors, SharePoint deployment, 1175–1176
form events, SharePoint deployment, 1175
form layout, modifying controls. See also forms, properties.
aligning controls, 314
calculated controls, creating, 316
control properties, 312
fields, adding to forms, 315–316
fields, listing, 314–316
Layout view, 312–315
tab order, specifying, 313–314
text, formatting, 314
form modules, 390
Form Name argument, 1060
Form ribbon
Align Center command, 293
Align Left command, 293
Align Right command, 293
Clipboard group, 292
Copy command, 292
Cut command, 292
Design tab, 314
Design view, 292
Find group, 293
Format Painter command, 292–293
Gridlines command, 293
Home tab, 291–293
Paste Append command, 292
Paste command, 292
Paste Special command, 292
Records group, 293
Size to Fit Form button, 293
Sort & Filter group, 293
Switch Windows button, 293
Text Formatting group, 293
Views group, 291–292
Window group, 29352_475348-bindex.indd 130052_475348-bindex.indd 1300 4/1/10 2:02 PM4/1/10 2:02 PM