Incorrect ColumnHeads

  • Thread starter Thread starter NEMO2K
  • Start date Start date
N

NEMO2K

Hi All,

is there somebody who can help me giving me a suggestion
for understanding the reason why the ColumnHeads of a
ListBox are not he same I can see in the query whom it is
based on?
Thanks,

NEMO2K
 
Open your table in design view.
Is there anything in the Caption property of these fields?
If so, you will probably see the Caption value in the Column Heads.
If not, you should see the Field name.

If you see something completely unrelated, try unchecking the boxes under:
Tools | Options | Name AutoCorrect
and then compact the database.

If you want to define a different name for the column heads, then alias the
fields. For example, you could set the RowSource of your list box like this:
SELECT [SomeField] AS [The Name You Want To See],
[Another Field] AS [The Name To Show For 2nd Column]
FROM [MyTable];
 
Hi Allen,

you're right: I had some values (the ones I didn't want to
see) in the Caption property of my table.
Thank you,

NEMO2K
-----Original Message-----
Open your table in design view.
Is there anything in the Caption property of these fields?
If so, you will probably see the Caption value in the Column Heads.
If not, you should see the Field name.

If you see something completely unrelated, try unchecking the boxes under:
Tools | Options | Name AutoCorrect
and then compact the database.

If you want to define a different name for the column heads, then alias the
fields. For example, you could set the RowSource of your list box like this:
SELECT [SomeField] AS [The Name You Want To See],
[Another Field] AS [The Name To Show For 2nd Column]
FROM [MyTable];

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi All,

is there somebody who can help me giving me a suggestion
for understanding the reason why the ColumnHeads of a
ListBox are not he same I can see in the query whom it is
based on?
Thanks,

NEMO2K
Click to expand...


.
Click to expand...
 
Back
Top