32bit 64bit / vba vba7 (which am I running?)

[markjkubicki]

I need to adjust code for users with a variety of 32 or 64bit, ACCESS 2010 or 2013 ...AURGH (its a problem out of my control -truly)
So I set up code to test what is running, adding the PtrSafe code to any declare statements in 64bit... but its not working correctly
... set up some code to simply trace what's happening

problem is in the first test the answer is Win32, but then in the second, I get "vba7 - Win64"

wholly perplexed, Mark

... running ACCESS 2013
MsgBox SysCmd(acSysCmdAccessVer) yields 15.0


If Win64 Then


MsgBox "Win64"
Else
MsgBox "Win32"
End If


If VBA7 Then
If Win32 Then
MsgBox "vba7 - win32"
Else
MsgBox "vba7 - win64"
End If
Else
If Win32 Then
MsgBox "NOT vba7 - win32"
Else
MsgBox "NOT vba7 - win64"
End If
End If

[ItsMe]

I do not have a 64bit version to test but I would try something like this.

If VBA7 Then
MsgBox "64bit"
Else
MsgBox "32Bit"
End If