hi all,
i hope to find solution for my problem.

I want to retreive current user name in windows by VBA.

For example if I have textbox and bottun in a form.
I want if I click the bottun, the user name for windows will be displayed in the textbox.

Please help.

Hi,

Use Environ$("Username")... this should give the Username, but may also return a little bit of extra text, ie: USERNAME=xxxx instead of just xxxx, so you will have to test it out on your environment, either way with a function set up to handle the extra text you should be flying fairly quickly.

ie:

if left(environ$("USERNAME"),9) = "USERNAME=" then
 right(environ$("USERNAME"), len(environ$("USERNAME")-9)
else
 environ$("USERNAME")
end if

Hope it helps.

Lee

Thank you very very much.
That's it