I'm sure there must be an easier way but I've never learnt VB or MS Access.
On my form I have an option group with 7 option buttons.
When any of them is chosen, Access keeps the data as a value.
The problem was that when I made a query based report, I saw those values only instead of the text.
So, I created a new query and I "translated" the value back to text by an expression coloumn.
(7) American Express
For Each ctrl As Control In Me.Controls("pnlMainPanel").Controls
If ctrl.GetType Is GetType(System.Windows.Forms.Panel) Then
For Each subCtrl As Control In ctrl.Controls
If subCtrl.GetType Is GetType(System.Windows.Forms.TextBox) Then
If subCtrl.GetType Is ...