How to change Text in column headings

[skelley]

How to change column headings text in a SUBFORM. I've tried everything. Please help.

 

[Atomic Shrimp]

Did you just want to do this in form design, or in VBA;

You should just be able to open up the subform in design view, click on the text box (not the label for it) and change the Name Property.

Note that access tries to be helpful in cases where you are changing the capitalization fo a name only (if you try to change the name 'FIELDNAME' to read 'Fieldname', access will change it back to the way it was) , but if you change 'FIELDNAME' to 'xyz' then click away and back, then change 'xyz' to 'Fieldname', it will accept the change.

If you want to change the name of the field in VBA, you'll have trouble as you need to refer to the object by the name that you want to change.

Is this any help?

Mike

 

[Rich@ITTC]

Hi Skelley

I agree with Mike that you need to go into Design view of the subform, but I would not normally change the name of the text box itself (assuming you have already wisely used a naming convention and called your text box txtFieldName rather than just FieldName or Text28 or similar). If the text box has an associated label then you only need to change the Caption property of the label to your preferred description.

You can programme VBA to alter the Caption value on opening a form (or on moving to a new record) but usually for labels/headings of columns in a subform that is rather too elaborate!

Hope that helps.