Hi,
I have a list box which is linked to a query. How can I manipulate the underlying SQL to change the column names so they display in a meaningful way?
Thanks in anticipation of any help.
Rob
Hi,
I have a list box which is linked to a query. How can I manipulate the underlying SQL to change the column names so they display in a meaningful way?
Thanks in anticipation of any help.
Rob
In your query you can use an alias so something like
Select YourField1 As 'Better Visual Name' , YourField2 as 'Nice Name Two' etc etc
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
You can also hide the listbox column headers and use your own labels above the columns.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
if using a query you can use the field or column caption property (OK, not manipulating sql, but achieves the same thing)