Column Headings on a List Box

[Wendy]

Hi

I have an unbound list box on a form and I would like to put my own titles
above the fields. I can only see a columnheading yes/no property, and that
shows the field names as in the table. I would like them to be a bit more
user friendly. Is it possible to use my own headings?

Thanks

Wendy

 

[Allen Browne]

How about use an Alias for the fields in the Row Source property of the list
box?

Example:

SELECT FirstName AS [First Name],
FamilyName AS [Family Name]
FROM Table1;

 

[Ron2005]

In design mode put

First Name:[FirstName]

etc.

 

[Wendy]

That works. Thanks Guys.

Wendy