list box column headings

  • Thread starter Thread starter Mark
  • Start date Start date
M

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!!!
 
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
 
Back
Top