Column heads for unbound combo box

[Vickie English via AccessMonster.com]

Hi everyone,

I have an unbound combo box which contains [Lastname, firstname] and [MI]
in two columns. I would like to display column heads. I set the column
heads property to 'yes' but the first heading is Expr101. I guess this is
because I have an expression allowing the name to display as lastname,
firstname. How do I get the first column head to be 'Name' instead of
this 'Expr101' business? can someone please help a distressed Vickie?
Thanks.

Vickie E.

 

[rowiga]

Click on the Row Source line of the combo box and then click on the ellipse
to see the underlying query. In the "Field" row look for "Expr101" and rename
it whatever you want the heading to display.

 

[Joan Wild]

I have an unbound combo box which contains [Lastname, firstname] and
[MI] in two columns. I would like to display column heads. I set the
column heads property to 'yes' but the first heading is Expr101.

Open the Row Source for the combo box (click on the build button). In the
QBE change the 'field' from
Expr101:[Lastname] & ", " & [firstname] to
Name: [Lastname] & ", " & [firstname]

 

[Vickie English via AccessMonster.com]

Thanks rowiga; it works. Thanks so much.
VE

 

[Vickie English via AccessMonster.com]

Thanks Joan; that was very very helpful. It worked. Thanks again.
VE