Microsoft KB Archive/94192

= ACC: Incorrect Characters in Crosstab Query Column Headings =

Article ID: 94192

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q94192



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
If the data in a field that is used as a column heading in a crosstab query contains a period (.), an exclamation mark (!), or a bracket ([ or ]), the character will be changed to an underscore character (_) in the column heading. This does not happen if the same data is used as a row heading.



CAUSE
Queries can be used as input to other queries, forms, or reports, and therefore column headings must be formatted as field names. Because field names cannot contain periods (.), exclamation marks (!), or a bracket ([ or ]), these characters are converted to underscore characters (_) in the column headings of the crosstab query.

Field names also cannot contain control characters (ASCII values 0 through 32). Additionally, the backquote character (`) cannot be used in field names in Microsoft Access 2.0 or later. Although these characters may appear in the column headings of the crosstab query (usually as a square for control characters) instead of being converted to an underscore, you will not be able to use the query as input to other queries and reports because of the invalid field names.



STATUS
This behavior is by design.

