[b]Using Environ("USERNAME")[/b]

[Jean9]

I am using UCase(Environ("USERNAME")) to gather the information and use it as a default value for a control on a form. I coded Me.OPERATOR.DefaultValue = UCase(Environ("USERNAME")) in the OnOpen event but when the form is opened the #Name? is in the control. What am I missing?
Thanks for your help,
J9

 

[straybullet]

Perhaps OnLoad rather than OnOpen.

Let them hate - so long as they fear... Lucius Accius

 

[Jean9]

No Dice on either event.

 

[djayam]

Hi Jean9,

I have a desktop and a laptop, both running Access 2003 on Windows XP Pro SP2. On the laptop, Environ("Username") works fine, on the desktop I get #Name. I have no idea why except that my desktop is in pretty bad shape over all. Try running your DB on a different machine to see if it's your code or something else...

Jason

 

[straybullet]

Does it still throw the error without the UCase; just Environ("UserName")? Is the control's name the same as the underlying field? Perhaps rename it txtOperator, or something along those lines.

Let them hate - so long as they fear... Lucius Accius

 

[ZOR]

Have you tried a google search for Environ("UserName")
I tried it and a few references came up. Anything on this one?

http://www.databasedev.co.uk/get_username_or_computername.html

Just thought I'd throw it in while your waiting