1290
Index
OLE Object data, 226
text data, 225
datasheets, displaying records
field display width, modifying, 237
hiding/showing records, 237
rearranging fields, 235–236
record display width, modifying, 238
resizing field width, 237
resizing record height, 238
datasheets, modifying data
adding records, 234
aligning data, 241
background color, modifying, 239–241
coloring alternate records, 239–241
copying and pasting, 231–233
deleting records, 234–235
display fonts, modifying, 239
editing techniques, 231
field display width, modifying, 237
freezing records, 242
gridlines, hiding/showing, 239
gridlines, modifying appearance of, 240
hiding/showing fields, 241
highlighting alternate records, 239–241
protected fields, 231
rearranging fields, 235–236
record display width, modifying, 238
replacing existing values, 230, 233–234
resizing field width, 237
resizing record height, 238
saving changes, 242
undoing changes, 231
datasheets, records
* (asterisk), new record indicator, 221–222
adding, 220–223
automatic data-type validation, 224–225
deleting, 220
filtering, 220, 242–246
hiding, 220, 238
saving, 220, 223
sorting, 220, 242–243
data-type errors, action queries, 676
Date data type, VBA, 428
Date fields
comparison operators, 152
data entry, 298
importing/exporting, 624–627
query selection criteria, 151–152
selection criteria for, 151–152Datasheet window, navigating (continued)
overview, 227
between records, 227–228
datasheets
aligning data, 220–221
coloring alternate records, 220
creating, 10
cutting/copying/pasting data, 220
data aggregation, 247–248
data sources, 216
definition, 10
displaying data, 10
fields, 216–217
find and replace records, 220
Find group, 220
forms, 262
go to a specific record, 220
gridlines, hiding/showing, 220
highlighting alternate records, 220
illustration, 216
justifying data, 220–221
line breaks, inserting, 231
modifying, 10
navigating, 599
opening, 221
overview, 215–216
printing, 248–249
records, 216–217
Records group, 220
resizing, 220
Size to Fit Form button, 220
summing rows and columns, 247–248
Switch Windows button, 220
text formatting, 220–221
Text Formatting group, 220–221
totals calculation, 247–248
views, switching, 219
Window group, 220
windows, switching, 220
datasheets, data entry
* (asterisk), new record indicator, 221–222
adding new records, 220–223
automatic data-type validation, 224–225
Currency data, 226
Date/Time data, 225
input masks, 225
Memo data, 226–227
Number data, 22652_475348-bindex.indd 129052_475348-bindex.indd 1290 4/1/10 2:01 PM4/1/10 2:01 PM