default value in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I've got a column 'creator' in my table. Is there way I can make it's
default value
something like currentuser?
Thanx

alekm
 
Not in a table.

If you use a form for input (as you should), you can assign CurrentUser as
the default for the textbox linked to the Creator field.
 
Assuming that [creator] is a text field, you could use "currentuser" as the
default - simply enter that value in the default line of the field property
list. Note that this will apply only when adding new records.

Of course Doug is correct, data entry should be done on a form (which also
can have a default value set for that particular bound control).
-Ed
 
Back
Top