Set a Field's Default Value as Windows User Name

[JithuAccess]

Hello Guys,

I have a field "Data Entry By" and there are 10 Staffs using the database. Is it possible, to set the default value of "Data Entry By" field as Windows User Name?

For Example, if a user ABC123 is using the Form for Data Entry, in the Table, I want to display ABC123 as "Data Entry By". I will not be showing "Data Entry By" in the Form. We are using Windows10 Enterprise

Is it possible.

 

[Gasman]

Look at the Environ() function for the simplest, if not the most secure way.

 

[JithuAccess]

Look at the Environ() function for the simplest, if not the most secure way.

Thanks a lot. It works

 

[theDBguy]

In case you're interested, here's another approach without using API but a little more secure than Environ().

Code Snippets (accessmvp.com)