How to print the user name on a report ?

[Guest]

I have a shared data base and I want to add the user name on the report
footer upon printing, could it be? Thanks.

 

[Guest]

In the report text box Control source you can write

=Application.CurrentUser

 

[aaron.kempf]

this assumes that you're using Access Security?

ROFL

if you used Select Suser_sname() you should be able to do this without
finding some obscure getusername API call

google getusername or look at mvps.org/access

or.. if you've got the balls to get a long term solution then move to
ADP and use the built in SUSER_SNAME()

 

[Guest]

Thanks Ofer.
M.A.Halim

In the report text box Control source you can write

=Application.CurrentUser