getting user name on report?

[Jens]

Hello,
Can someone please help me out. I have a access
database that people log into. THere are certain people
who can print certain reports, and then those who can't.
I would like to put the username of the person who is
logged in on the bottom of a report when they print it.
Does anybody have any ideas? Any help will be greatly
appreciated.

Thanks,
Jens

 

[chas]

Hi Jens,

place an unbound TextBox control where you need it, view
the properties for the TextBox and in the RecordSource
property type:

=CurrentUser()

hth

chas

 

[Fredg]

Jens,
As the control source of an unbound control:
=CurrentUser()

 

[Duane Hookom]

I don't think CurrentUser() will do you any good if you are not implementing
Access security. If you want the network login then use the code found at
http://www.mvps.org/access/api/api0008.htm. Then just add a text box with a
control source of:
=fOSUserName()