1288
Index
sorting, 50, 147
types of data stored, 49
data types, Text
converting from AutoNumber, 58
converting from Date/Time, 58
description, 51
group headers, 362
purpose, 48
storage size, 49
data types, VBA variables
Boolean, 428
corresponding Access data types, 428
Currency, 428
Date, 428
Decimal, 428
default, 426, 430
Double, 428
Integer, 428
Long, 428
Object, 428
Single, 428
specifying, 422
String, 428
supported by VBA, 428
Variant, 428, 430
data types, Yes/No
automatic validation, 224–225
converting to Text, 58
description, 53
purpose, 48
storage size, 49
data validation rules
AllowZeroLength property, 70–71
business rules, enforcing, 69
date/time data, limiting to a range of dates, 70
error messages, 69
input, 69–70
nonexistent data, 71
required data, indicating, 70
Required property, 70
specifying, 49
unknown data, 71
Validation Rule property, 69
Validation Text property, 69
zero-length data, allowing, 70–71
Database Enhancement dialog box, 32–33
Database object, 502data types, AutoNumber
converting from other data types, 57
converting to Number, 58
converting to Text, 58
overview, 53
problems, 1179
purpose, 48
storage size, 49
data types, Currency
automatic validation, 224–225
converting to Number, 58
converting to Text, 58
default value, 59
description, 53
entering, 226
group headers, 363
purpose, 48
storage size, 49
VBA, 428
data types, Date/Time
automatic validation, 224–225
converting to Text, 58
description, 53
entering, 225
group headers, 362
leading zeros, enabling, 625
purpose, 48
storage size, 49
data types, Memo
converting to Text, 58
indexing, 50
overview, 52
purpose, 48
sorting, 50
storage size, 49
data types, Number. See also numeric fields.
converting from AutoNumber, 58
converting to Currency, 58
converting to Text, 58
default value, 59
group headers, 363
overview, 52–53
purpose, 48
storage size, 49
data types, OLE Object
converting to other data types, 58
description, 54
indexing, 50, 7352_475348-bindex.indd 128852_475348-bindex.indd 1288 4/1/10 2:01 PM4/1/10 2:01 PM