aqif
Registered User.
- Local time
- Today, 01:10
- Joined
- Jul 9, 2001
- Messages
- 158
Hi
Is there any way by which I can loop through all text boxes and get 2 pieces of information
1. Control Source (Name of field) - I have already managed to do so
2. Caption of the attached label of the text box
The objective is to give a list of label captions and their corresponding fields so that the other developer knows what field name relates to what question. Therefore, I need a table something like this
Form Name Field Name Label Caption
----------------------------------------------------
Form1 IDNum Record ID Number
Form1 PtFName First Name
I can easily get Form Name and Field Name by looping through the control source of all the text boxes but I can't figure out a way to get the name or caption of the attached label.
Any help will be greatly appreciated.
Regards
Aqif
Is there any way by which I can loop through all text boxes and get 2 pieces of information
1. Control Source (Name of field) - I have already managed to do so
2. Caption of the attached label of the text box
The objective is to give a list of label captions and their corresponding fields so that the other developer knows what field name relates to what question. Therefore, I need a table something like this
Form Name Field Name Label Caption
----------------------------------------------------
Form1 IDNum Record ID Number
Form1 PtFName First Name
I can easily get Form Name and Field Name by looping through the control source of all the text boxes but I can't figure out a way to get the name or caption of the attached label.
Any help will be greatly appreciated.
Regards
Aqif