Customize Combo box Colum Heads?

[Guest]

Is there a way to customize the column headings in a combo/list box? The
current column headings are short and confusing and I'd like to give them
better names.

For example, current Column Name is ADD1. I'd like to use "Address" as the
column heading.

Thanks.

 

[Ken Snell \(MVP\)]

Use a query as the RowSource, and use alias names for the fields:

SELECT ADD1 AS Address, NameX AS EmpName,
ID AS EmpID
FROM YourTableName;

The alias names will appear in the combo box's header row.

 

[Carl Rapson]

Is there a way to customize the column headings in a combo/list box? The
current column headings are short and confusing and I'd like to give them
better names.

For example, current Column Name is ADD1. I'd like to use "Address" as the
column heading.

Thanks.

In the Row Source, use AS to redefine the column names:

SELECT ADD1 AS Address, field2 AS name2, ...

Carl Rapson

 

[Guest]

Thanks to you both! That was almost too easy...

In the Row Source, use AS to redefine the column names:

SELECT ADD1 AS Address, field2 AS name2, ...

Carl Rapson