Rename a field in design view

[eclipse33]

Hi,

I am trying to rename a field in design view of a query.

I have Phone #honeNumber in the field name but I keep getting Phone. as the field header when I export it to Excel?

If I view it in Datasheet view in Access it shows Phone # but not in Excel.

Any ideas?
eclipse33

 

[grnzbra]

I don't know, but...

Perhaps it works like the &. If a label of a control is
&Enter you get Enter with a line under the E. If you want it to say
&Enter you set the caption to &&Enter

Try Phone ##hone Number

 

[eclipse33]

nope...weird!

now I get Phone..

Anyone know why the # is changed into a .?