Control Statements - Access Database Design and Programming - page 189

Table 13-3. Format function examples
Expression Return value [1]

F ormat(Date, “Long Date”) T hursday, April 30, 1998

Format(Time, “Long Time”) 5:03:47 PM

F ormat(Date, “mm/dd/yy hh:mm:ss AMPM”) 0 4/30/98 12:00:00 AM

Format(1234.5, “$##,##0.00”) $1,234.50

F ormat(“HELLO”, “<“) “ hello”

[1] The exact format of the return value is governed by certain system settings.