Datasheet View

  • Thread starter Thread starter Simon Glencross
  • Start date Start date
S

Simon Glencross

Does anyone know how to change the names on column headers I have looked
everywhere but can not find anything??
 
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.
 
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
 
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.
 
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
 
Back
Top