Datasheet View

S

Simon Glencross

Does anyone know how to change the names on column headers I have looked
everywhere but can not find anything??
 
B

Brian Wilson

Simon Glencross said:
Does anyone know how to change the names on column headers I have looked
everywhere but can not find anything??
Click to expand...


Are you talking about the datasheet view of a form rather than viewing the
tables/queries directly? If so, then make sure that you textboxes have
attached labels. The caption of the label is what will appear as the column
headings. This is my preferred approach but there are others such as
setting the caption property of the field in the design view of the table
but I find this has irritating side-effects. Another approach is to use a
query which uses field aliasing such as "SELECT ConID AS ID, ConLastName AS
Surname FROM tblContact" so that you change the names of the columns in your
datasource, eg ConLastName to Surname.
 
A

Amy Blankenship

If you set the caption property in the table design, this will automatically
give that caption both to the table columns in datasheet view and the
default label when you create a field in form view.

HTH;

Amy
 
B

Brian Wilson

Amy Blankenship said:
If you set the caption property in the table design, this will
automatically give that caption both to the table columns in datasheet
view and the default label when you create a field in form view.

HTH;

Amy
Click to expand...



Was this not one of the 3 methods I mentioned? The extra things this will
automagically do are the irritations to which I refer.
 
D

David

Brian,

Good suggestion. I tried this in the SQL statement, only to get an error:
SYNTAX ERROR in the FROM CLAUSE.

I am trying to use data from another query, in this query, to get a column
name:

.... MasterCriteria.CriteriaValue1 AS CriteriaDesc1 FROM qryCriteriaHeadings...

Any ideas?

Thanks,

--David
 
Top