change column title in a subform

[Guest]

HI all,

I have a subform, in the detail section, I use textboxes to display fileds.
I would like to display time dynamically in the column title positions,
but the column title of each field is the name of the textboxes.How can I
control the display of the column title or use textbox to cover it.

Clara thank you so much for your help

 

[Guest]

Hi clara,

The label associated with the textbox controls the title of the column (I
assume you are talking about datasheet view). To change this, have an event
in the On Current event of your main form that does something like this:

me.SUBFORMNAME.form.LABELNAME.caption = TIME_FORMAT

Hope this helps.

Damian.