View Single Post
  #2  
Old March 25th, 2009, 10:01 PM posted to microsoft.public.access.tablesdbdesign
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default Default value in table field (username and computername)

I believe it should work in Access 2007 as well, although I always cringe
when I see people use the Environ function to return the user ID given how
easy it is to change.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"mario" wrote in message
...
This used to work fine in Access 2003 to insert a default value in a
field.
=Environ("USERNAME") & " on " & Environ("COMPUTERNAME")

Can you please let me know what is the equivalent in Access 2007