list box column headings

[Mark]

Hi,

I have a list box with the following row source:

SELECT [queryRegistrationApproval].[EmployeeID],
([queryRegistrationApproval].[EmployeeLName]) & ", " &
([queryRegistrationApproval].[EmployeeFName]),
[queryRegistrationApproval].[ClassID] FROM
queryRegistrationApproval;

Basically, the list box has 3 columns
(employeeID/lastname,firstname/ClassID). I would like to
display the column headings... if I select "yes" to column
heads in the property box I get "Expr1001" instead of
having "Employee LastName,FirstName". Is there a way to
customize this heading to do this?

Thanks for your help!!!

 

[Luiz Cláudio]

Hi Mark,

try something like this:

SELECT Field1 AS [Name of the field]
FROM YourTable;

[]
Luiz Cláudio C. V. Rocha
São Paulo - Brazil
MVP Office