Free E-Books

The following sections discuss some
of the more important and frequently used field properties.
The following sections include many references to properties, and property settings in
the Access table designer. The formal name for a property (such as DefaultValue)
never contains a space, while the property??™s expression in the table designer usually contains a space
for readabilty (Default Value). These relative minor differences become important when referencing
properties in expressions, VBA code, and macros. When making a formal reference to a property in
code or a macro, always use the ???spaceless??? version of the property??™s name, not the property reference
you see in the Access user interface.
Common properties
Here is a list of all the general properties (note that they may not all be displayed, depending on
which data type you chose):
n Field Size: When applied to Text fields, limits size of the field to the specified number of
characters (1??“255). The default is 50.
n New Values: Applies to AutoNumber fields.


Pages:
249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273