default value in table

A

alekm

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
 
D

Douglas J. Steele

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.
 
E

Ed Robichaud

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
 
Top