1301

Index

yy:, formatting two digit year, 63

yyyy:, formatting four digit year, 63

formatting, input masks

: (colon), date/time separator, 67

, (comma), thousands separator, 67

. (period), decimal points, 67
; (semicolon), input mask separator, 67
A, required letter or digit indicator, 67
a, optional letter or digit indicator, 67
& (ampersand), any character or digit required, 67
\ (backslash), literal text indicator, 67

• (dash), input mask separator, 67
  ! (exclamation point), displaying input masks, 67
  / (forward slash), input mask separator, 67

  
  

  (greater-than sign), convert to uppercase, 67
  < (less-than sign), convert to lowercase, 67

  
  

  (pound sign), optional digit indicator, 67

  
  

  ? (question mark), optional letter indicator, 67
  0 (zero), required digit indicator, 67
  9 (nine), optional digit indicator, 67
  C, any character or digit optional, 67
  Input Mask property, 66–68
  Input Mask Wizard, 67–68
  L, required letter indicator, 67
  phone numbers, 66–68
  Social Security numbers, 66–68
  formatting, memo fields
  & (ampersand), optional character indicator, 64
  @ (at sign), required character indicator, 64
  (greater-than sign), convert to uppercase, 64
  < (less-than sign), convert to lowercase, 64
  examples, 65
  formatting, text fields
  & (ampersand), optional character indicator, 64
  @ (at sign), required character indicator, 64
  (greater-than sign), convert to uppercase, 64
  < (less-than sign), convert to lowercase, 64
  examples, 65
  input masks, creating, 68
  painting formats, 292–293
  formatting reports
  aligning control labels, 736
  blank lines, inserting, 731–733
  bulleted lists, 723–725
  centering titles, 736
  color, 368–369
  column layout, specifying, 745
  column spacing, specifying, 745

  
  

  
  

placeholders, 62

Required property, 70

Scientific format, 61

Standard format, 61

Sub-Address property, 66

thousands separator, 62

Validation Rule property, 69

Validation Text property, 69

Yes/No fields, 65–66

formatting, date/time fields

: (colon), separating time elements, 63

/ (forward slash), separating time elements, 63

am/pm:, lowercase 12-hour format, 64

AMPM:, uppercase 12-hour format, 64

a/p:, lowercase 12-hour format, 64

A/P:, uppercase 12-hour format, 64

built-in formats, 62–63

c:, General Date format, 63

custom formats, 63–64

d:, formatting day of the month, 63

dd:, formatting day of the month, 63

ddd:, formatting day of the week, 63

dddd:, formatting day of the week, 63

ddddd:, Short Date format, 63

dddddd:, Long Date format, 63

General Date format, 63

h:, formatting hours, 64

hh:, formatting hours, 64

input masks, creating, 68

Long Date format, 63

Long Time format, 63

m:, formatting month of the year, 63

Medium Date format, 63

Medium Time format, 63

mm:, formatting month of the year, 63

mmm:, formatting month of the year, 63

mmmm:, formatting month of the year, 63

n:, formatting minutes, 64

nn:, formatting minutes, 64

q:, formatting quarter of the year, 63

s:, formatting seconds, 64

Short Date format, 63

Short Time format, 63

ss:, formatting seconds, 64

tttt:, Long Time format, 64

w:, formatting day of the week, 63

ww:, formatting week of the year, 63

y:, formatting day of the year, 63

52_475348-bindex.indd 130152_475348-bindex.indd 1301 4/1/10 2:02 PM4/1/10 2:02 PM