Environ(“MyEnvâ€)

[JIM.H.]

I am using MS Access 2003. I have this in the code

myVar=Environ(“MyEnvâ€)

and I see this works, however when I put a textbox in a form and set source
control as Environ(“MyEnvâ€), it seems it does not work.
What is problem?
Thanks,

 

[Dirk Goldgar]

I am using MS Access 2003. I have this in the code

myVar=Environ("MyEnv")

and I see this works, however when I put a textbox in a form and set
source control as Environ("MyEnv"), it seems it does not work.
What is problem?

Did you precede the funtion call, in the controlsource, with an equals
sign:

=Environ("MyEnv")

?

 

[JIM.H.]

with equal sign. I but =Environ("MyEnv") into control source.

 

[Dirk Goldgar]

with equal sign. I but =Environ("MyEnv") into control source.

It works for me (though I'm using A2002), so what you're seeing may be
the result of your registry setting for Jet sandbox mode. See this MS
KnowledgeBase article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;294698

I have this set to 2: "Sandbox mode is used for non-Access applications,
but not for Access Applications."