Customize Combo box Colum Heads?

M

Mcrawford

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.
 
K

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.
 
C

Carl Rapson

Mcrawford said:
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.
Click to expand...

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

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

Carl Rapson
 
M

Mcrawford

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

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

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

Carl Rapson
Click to expand...
 
Top