Datasheet View

[Simon Glencross]

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

 

[Brian Wilson]

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

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.

 

[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

 

[Brian Wilson]

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

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

 

[Guest]

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