Control heading on datasheet

T

Tony Williams

I have a subform which is a datasheet. How do I get the control headings to
show the caption rather than the control name?
TIA
Tony
 
P

Penguin

Have you tried using a continuous form? You can show your captions in
the form header.
 
E

Eric Schittlipz

Tony Williams said:
I have a subform which is a datasheet. How do I get the control headings to
show the caption rather than the control name?
TIA
Tony

Give the controls attached labels - like the normal textbox and label
combination you get when you drag a textbox onto a form. Then the field in
the recordsource might be ConLastName, the textbox named "txtConLastName",
the attached label named "lblConLastName" and its caption property set to
"Surname". Then you simply see "Surname" as a column heading.
 
T

Tony Williams

Thanks Eric!
Tony
Eric Schittlipz said:
Give the controls attached labels - like the normal textbox and label
combination you get when you drag a textbox onto a form. Then the field in
the recordsource might be ConLastName, the textbox named "txtConLastName",
the attached label named "lblConLastName" and its caption property set to
"Surname". Then you simply see "Surname" as a column heading.
 
Top