I have a data sheet form and would like to be able to change the field names shown across the top of the from, the values for the headings coming from a table. Is is possible to acheive in VBA when the form loads.

Unfortunately datasheet forms seem to be notorious for not following their prescribed captions. I had the devil's own time trying to do it, and eventually gave up and made a continuous form with very narrow boundaries between the fields. Then I could label them however I wanted. If someone does know the trick, I'll be most pleased to know as well.

HTH,
David R

Better late than never I hope. If you have the labels attached to the text boxes, what is entered in the lable for a caption will display as the column header. If the text box has no label, create a label with the appropriate caption, cut it, select the correct text box and right-click, paste. This will attach it to the text box.

HTH,
Shawn