Field names with spaces

[Mod]

How can i refer to a field name of a RecordSet variable if the field in question has a space or other funky character?

REM the name of the field in this example is Field #Name

Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("Table 1")
...
SubRoutine(rst!Field #Name)
SubRoutine(rst!Field\ \#Name)
SubRoutine(rst!"Field Name")

And I can't think of anything else to try

 

[CCIDBMNG]

How can i refer to a field name of a RecordSet variable if the field in question has a space or other funky character?

REM the name of the field in this example is Field #Name

Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("Table 1")
...
SubRoutine(rst!Field #Name)
SubRoutine(rst!Field\ \#Name)
SubRoutine(rst!"Field Name")

And I can't think of anything else to try

SubRoutine(rst![Field Name])

 

[namliam]

which is exactly why you shouldnt use spaces in names ..... *geez*