Table field renamed?

[darkhat01]

This seams weird to me, but maybe someone can explain this to me.

If I open up a table in design view and look at a field it is called abc, now if I go into datasheet view and I look at the column heading I am getting a name called "Does this issue involve..." Why and how does this happen? Why is it not called abc for the field in design view but something else in datasheet view? This field is linked to a form.

Thanks,

darkhat

 

[PHV]

When in design view have a look at the Caption property of the abc field.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[darkhat01]

It's the samething... Nice... So if I put something in caption then it will always show what is there in datasheet view?

Thanks PHV...

 

[dhookom]

Good reason to never ever use the Caption property in table design view. Same goes for lookup fields and other properties that I completely ignore in table design.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Remou]

And furthermore, Description gets put in Status Bar Text, which I find very annoying.