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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200911/1

[Scott_Brasted via AccessMonster.com]

[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.

Scott_Brasted wrote:
>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

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

[Benjamins via AccessMonster.com]

Hi,

You can create a label and associate it with the text box. The label will
become the column header.
OR
You can change the Control Name.

Other than that, there is no other way. (From what i know)

[Scott_Brasted via AccessMonster.com]

Many thanks for the reply. I should have looked first before posting. It
seems there are a lot people trying to format datasheets. I have taken the
route of using continuous forms when I need formatting and datasheets when I
can change control names.

Hapy Thanksgiving
Scott

Benjamins wrote:
>Hi,
>
>You can create a label and associate it with the text box. The label will
>become the column header.
>OR
>You can change the Control Name.
>
>Other than that, there is no other way. (From what i know)
>

>>Greetings again,
>>
>[quoted text clipped - 7 lines]