MSAccess database with Basic - accessing fields

Question

Hello,

First time I'm touching both access and basic, but I'm doing a favor for my sister. I have to retrieve data from a table and some headings have a % character in them and changing the headings is not and option. what does msaccess replace % with?

Let Entitlement = rc![Entitlement% pozitia 1]

rc is the recordset :P

Answer 1

I have no Access db handy to test at the moment,
but you might try displaying the field names: (code from here)

Public Sub GetTableObjects()
   Dim db As Database
   Dim tbl As TableDef
   Dim Fld As Field
   Set db = CurrentDb
   For Each tbl In db.TableDefs
     Debug.Print "Table: " & tbl.Name & " ***"
       For Each Fld In tbl.Fields
         Debug.Print Fld.Name
       Next Fld
   Next tbl
End Sub