Whatever you enter as text in the title or subtitle of a query, will be output unchanged, when printed, unless the text contains any of the special codes listed below, in which case these will treated specially. For example, '%#x' is a special code that can be used to print the current date in a particular format. Suppose a query had the following print title: "Boy's Names, %#x, Robson Family". If you printed this on 14/3/1995 (a Tuesday, let us say), the title actually printed would be "Boy's Names, Tuesday, March 14, 1995, Robson Family". In other words, special codes are substituted appropriately, but the remaining text is printed unchanged.
All special codes begin with a '%' character. If you wish a title or subtitle to contain an ordinary '%' character - i.e. not as part of a special code - you should enter it twice. For example, if your print title is "90%%", this will appear on paper, when printed, as "90%".
A complete list of special codes is given below.
| Format Code | Meaning |
|---|---|
| %a | Abbreviated weekday name |
| %A | Full weekday name |
| %b | Abbreviated month name |
| %B | Full month name |
| %c | Date and time representation appropriate for locale |
| %d | Day of month as decimal number (01 - 31) |
| %H | Hour in 24-hour format (00 - 23) |
| %I | Hour in 12-hour format (01 - 12) |
| %j | Day of year as decimal number (001 - 366) |
| %m | Month as decimal number (01 - 12) |
| %M | Minute as decimal number (00 - 59) |
| %p | Current locale's A.M./P.M. indicator for 12-hour clock |
| %S | Second as decimal number (00 - 59) |
| %U | Week of year as decimal number with Sunday as first day of week (00 - 51) |
| %w | Weekday as decimal number (0 - 6; Sunday is 0) |
| %W | Week of year as decimal number with Monday as first day of week (00 - 51) |
| %x | Date representation for current locale |
| %X | Time representation for current locale |
| %y | Year without century as decimal number (00 - 99) |
| %Y | Year with century as decimal number |
| %z, %Z |
Either the time-zone name or time zone abbreviation, depending on PC settings; no characters if time zone is unknown |
| %% | Percent sign |
The # flag may prefix any formatting code. In that case, the meaning of the format code is changed as follows:
| Format Code | Meaning |
|---|---|
| %#a, %#A, %#b, %#B, %#p, %#X, %#z, %#Z, %#% | # flag is ignored. |
| %#c | Long date and time representation, appropriate for current locale. For example: "Tuesday, March 14, 1995, 12:41:29". |
| %#x | Long date representation, appropriate to current locale. For example: "Tuesday, March 14, 1995". |
| %#d, %#H, %#I, %#j, %#m, %#M, %#S, %#U, %#w, %#W, %#y, %#Y | Remove leading zeros (if any). |