Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
My DefaultValue stopped working RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I imported a spreadsheet into a table, and for a Date/Time field named "Created", I set a Default Value of "=Now()". This way, in Datasheet view, I was provided an editable timestamp on each record.

    Then I used the "Analyze Table" tool to split my table into several normalized tables. But now, in the new Items table, the same Default Value, fails to fill in the date.

    Image 1: Design of new Items table:

    Image 2: Datasheet View, New Record:

    Monday, March 30, 2020 12:41 AM

Answers

All replies