Auto populate textbox with current username.

[Guest]

If I have a form with a text box called txtInspector, is it possible to
automatically populate the text box with whoever is logged on to the
computer?

Dave

 

[Al Camp]

Dave,
Set the default value to
=CurrentUser

 

[Van T. Dinh]

Do you mean the Windows LogOnID? If so, see The Access Web article:

http://www.mvps.org/access/api/api0008.htm

 

[Guest]

This is exactly what I need, can you provide further instructions on how I
should apply this to my form. Does this apply to the whole form, or just the
text box I want to populate? The text box is named txtInspector.

Thank you
Dave

 

[Van T. Dinh]

I am not sure what you meant by "apply to this Form"???

If you simply want to display the Windows LogOnID in a TextBox on the Form,
set the ControlSource of the TextBox to:

= fOSUserName()

(including the equal sign)