W
WDSnews
I'm struggling with the Access Object Model. How can I address the fields
of my form when the field names are held in an array? My hope is to address
the fields similar to:
Me.Fields(strArray(iCount)).BackColor = RGB(&HF8, &HFF, &HA0)
This works:
Me.[Title].BackColor = RGB(&HFF, &HFF, &HFF)
This doesn't work:
Me.Fields("Title").BackColor = RGB(&HF8, &HFF, &HA0)
of my form when the field names are held in an array? My hope is to address
the fields similar to:
Me.Fields(strArray(iCount)).BackColor = RGB(&HF8, &HFF, &HA0)
This works:
Me.[Title].BackColor = RGB(&HFF, &HFF, &HFF)
This doesn't work:
Me.Fields("Title").BackColor = RGB(&HF8, &HFF, &HA0)