format headings in datsheet view for subform

[Scott_Brasted via AccessMonster.com]

Greetings again,

For a subform in datasheet view, is there a way to format the column headings
of the form? I have a control named txtName,so of course the subform dispays
the column header as txtName. Is there a way to change this without renaming
the control? Also, can the justification be changed. Cannot find any way in
property sheet. Is there a way in VB for the control? I already have code on
the control for a filter. Can it be added on to that?

Best,
Scott

 

[Scott_Brasted via AccessMonster.com]

Plese disregard as I have just read a lot of previous posts , all that
indicate datashhet is very inflexible.
Thanks,
Scott

 

[Linq Adams via AccessMonster.com]

They are the least flexible form views but this can be done with a little
grunt work.

Your form has to be based on a query, if it isn't already.

The query has to include all of the requisite fields.

You need to create calculated fields for all fields whose names you want to
change in the datasheet header.

To change the header for txtName to just plain Name,

in a new field in the Query Grid, enter tis

Name: [txtName]

Notice the colon between Name and [txtName]

Now, in your Datasheet, use the calculated field Name insteasd of txtName.

Plese disregard as I have just read a lot of previous posts , all that
indicate datashhet is very inflexible.
Thanks,
Scott

Greetings again,

[quoted text clipped - 7 lines]

Best,
Scott