Change listbox column head

[hansnyc]

How do I change the colum head in a list box?
I have a list box from a query drawing data from a table one of the item is refJOBID, i'f like that column head to just say JOB ID.
how is that possible?

 

[boblarson]

Go into the query that is supplying the recordsource of the list box and give it a name. So, in the QBE grid it would look like this:

JOB ID:[refJOBID]

In SQL it would look like

SELECT YourTableName.refJOBID As JOB ID

I am not good with SQL directly so I use the QBE grid. With spaces in the name you may have to use single quotes or something 'JOB ID'