Set Default Value to User Function in Table Design

C

Chertsey

I have 2 functions that find the user name and machine name. I want to set
these functions as the default value for the respective fields in the Table
design but it won't let me. However I can set them in a Form with the
respective fields on the form. Is this normal?
 
J

John W. Vinson

I have 2 functions that find the user name and machine name. I want to set
these functions as the default value for the respective fields in the Table
design but it won't let me. However I can set them in a Form with the
respective fields on the form. Is this normal?
Click to expand...

Yes. You cannot use user-defined functions in table defaults or in table
validation; you can on a form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set as Default Template not working 0
Problem with SET & REF function 0
Confusion over where user templates are stored in Word 1
Excel - Wich Function should I use? 1
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Doughnut Chart linked with the slicer in the pivot table 0
Setting column width in a table with a macro is not working 0
help with table design for Code Library 2

Top