Increment date fields

[Michaela]

I would like to increment date fields by 1 day every time
I tab into the field. I was able to do this in Access 97
but cannot figure it out in Access 2000. What am I
overlooking? Please help.

 

[Dennis Schmidt]

Hi Michael,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

If you use the OnEnter Event Procedure and the following code, you should
be good to go:

Me!FieldName = DateAdd("d", 1, [FieldName])

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support