Is it possible to edit column headings in a List Box?

[kmw]

I would like to edit the column headings without changing the field names, is this possible?

[TG_W]

Yes. Click in the Text Box and start typing. This might automatically change your box size. You can also click on the Text Box and change the Caption in the Format tab of the Property Sheet. This will not change the size of your Text Box.

Hope that helps.

[kmw]

I am having trouble because it is a list box not a text box. I haven't been able to click on my headings in any view.

[RayMilhon]

Yes you can but I don't believe you can do it without using VBA. You would have to set the value for each column in Row 0 to the header you want. although the last time I did it was in Access 2000 and I'm not sure what's changed in the listbox since then.

[Bob Fitz]

If the list box is based on a query or SELECT statement, then it can be done by changing the the query or statement. What is the Row Source property of the list box

[kmw]

it's a query

[Bob Fitz]

Open the query in design view.
In the field row, find the field that you want a different heading for. Lets say the field is called OldField. Change it to NewField:[OldField]

[kmw]

thank you!!

[Bob Fitz]

Glad we could help