user defined data types in VBA

Hi,
I have a fairly long type declaration
see example below:

rather than explicitly naming the type and element name (RptControl.ctlType
= "TextBox")
I'd like to automate the assignment say RptControl.ElementVariable = value

similarly, I'd like to access the values in a loop
for each element in rptcontrol
debug.print element.value
next

I tried to do that but was not terribly successful.
Thanks in advance for your suggestions
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9292-user-defined-data-types-in-vba.html

Regards
HS
--------------------------------------------
Type RptControl
ctlType As String
CtlNum As String
Alignment As String
BackColor As String
DisplayOptions As String
DisplayType As String
LinkType As String
LinkControl As String
Font As String
FontBold As String
FontColor As String
FontItalic As String
FontSize As String
FontUnderline As String
Format As String
FormatField As String
Pattern As String
PatternColor As String
PositionLeft As String
PositionTop As String
ReadingOrder As String
SizeHeight As String
SizeWidth As String
ZOrder As String
End Type


--
www.DynExtra.com
A resource for the Microsoft Dynamics Community
Featuring FAQs, File Exchange and more
Current member count: 21
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9292

--------------------------------------------

Share your knowledge. Add your favorite questions and answers


Help add questions to this site! We want Your input.

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!