default value in table

[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

 

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

 

[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