I'm looking for a way to change the heading names in a query, I have one field called complaintid but is only a 2 number field, I'd like it to read CID at the top so I can resize it. Thanks for all your help especially Bob.
Ray

oops, found it...I was using Description....

http://office.microsoft.com/global/images/default.aspx?AssetID=ZA790050011033Change a field's caption (javascript:ToggleDiv('divExpCollAsst_2'))


Open a query in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.) (javascript:AppendPopup(this,'defDesignView_7')).
In the design grid, click anywhere in the column of the field whose caption you want to change, and then click Properties http://office.microsoft.com/global/images/default.aspx?AssetID=ZA060445561033 on the toolbar.
In the Caption property box, type the new caption for the field.

I would strongly recommend against using the caption property. I have seen what it does in tables and I expect it is just as undesirable in queries.

Simply set the fieldname in the Design View field box view like this:

NewName: OriginalName

Galaxiom is 100% with that comment

the caption property is absolutely horrible used in tables. you end up struggling to know which data column you really have.

its akin to the other ways in which MS mixes form and function - the lookup field, the + option in a table, and so on. all best avoided.