I want to set a date and time stamp so I set up a field in the table and fill in the Default Value as =Now() (I have tried just Now()) on a text field (I have tried a Date field). I then save the change close and reopen the table add a new record.....no date and time & stamp, I then check the design and no default set!

I have tried to be as methodical as possible but must be doing something stupid but I can't see what.

Can anybody help?

If you can help on this please look at my posting of last week.

Hi,

   Try designing a quick table, put in an autonumber PK, a text field, and use the following for your date field:
Field Name: DateTime
Data Type: Date/Time
Default Value: =Now()

   Save and open the table. The Date/Time should automatically populate the DateTime field.

   If you are opening the table in a form, and the DateTime field is not on the form, try putting it on the form and setting visible to No or False for that field. Make sure it is high in the tab order for good measure.

Does this help?

mmcdonal

Thanks MMcDonal that is exactly what I did just after I posted my query. Guess what.....it worked, it was then that I noticed something about Now() in a default. The Now() is set in the next record so that when it is created it shows the time of the last creation (now I concede that I may be doing something really stupid but try it and see if I'm right). I have decided to write a VBScript which I'll attach to the new record button on the toolbar in a DAP.

Any takers for my posting of last week which poses me a greater problem (If I can't solve it I will be migrating my work to PHP/MySQL)