Getting a list of control names on a form
Fellow Access MVP John W. Vinson reported a client found an interesting "feature" within Access forms. If while on a form and in Form View hit Ctrl+A and then Ctrl+C. Now switch to Notepad and Ctrl+V to paste. Turns out you get the forms control names and then the field values all separated by vbTab. (Actually the control names and the field values are separated by a vbCrLF. And on a continuous form this includes all the records data values on that form.) This data looks terrible when you paste into Word but usable within Excel.
However I like the idea of Notepad. I needed a list of about ten fields I was going to enable or disable depending on a value. So from within Notepad I deleted the fields I didn't care about and of course the data values. Then I inserted carriage returns between the fields and removed the extra tab.
And now I have a nicely formatted list of fields I can paste into my VBA code module.
All I need now is to build a little Add-In of some sort that will remove all the data values and convert the vbTabs to vbCrLFs. That would save me oh, at least 10 or 20 seconds. <smile>
John, thanks for reporting this. You just saved me five minutes work every few months when I can use this. <chuckle>