CurrentUser()

[isladogs]

Even though Environ returns a string, in order to apply it to the Default Value property of a control you still need to wrap it in additional string delimiters

Me!YourTextBox.DefaultValue = """" & Environ("Username") & """"

That doesn't work either.


At least not when I tried it
However this should work

Add this function to a standard module

Public Function GetUserName()
     GetUserName = Environ("UserName")
End Function

Then in the control source or default value for your textbox, enter

=GetUserName()

[Beetle]

That doesn't work either.

I tested before posting. It does work, at least in my application, so not sure what the difference might be.

[orange]

@anthony

Can you describe again for clarity what exactly you want for username and password?
In the Steve Bishop video he uses and application specific login set up.

[anthony@aahs.us]

Beetle resolved it for me thank you

[isladogs]

I tested before posting. It does work, at least in my application, so not sure what the difference might be.

I had tested it by writing the formula you gave direct into the property sheet and that fails.
It does work if you put it in form load event.

However if you use a function as I suggested, that will also work in the property sheet.