I want to populate a listbox with all the field captions of a particular table, not the field names. Can I do this with access?
I want to populate a listbox with all the field captions of a particular table, not the field names. Can I do this with access?
Probably with VBA code that reads caption property. Bet have to use TableDefs collection to get that property. Review this http://bytes.com/topic/access/answer...tables-caption
Then use AddItem method to add rows to listbox.
Use a loop structure.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.