| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 34471 | 2003-06-14 01:41:00 | Repeating date in Access 2000 form | densm (4013) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 152453 | 2003-06-14 01:41:00 | Help with creating date in form To keep repeating the pervious date when entering data- At present I am using "Date ()" for todays date and if I want to enter data for an earlier date I have to change it to just "Date" and use the keys "Ctrl+' " to keep the same date as I enter data How can I automate this please? Thanks |
densm (4013) | ||
| 152454 | 2003-06-15 02:00:00 | You can set defaults for Date, Numeric, or Text fields with code similar to: ( AfterUpDate Event of your txt Box ) Private Sub DateField_AfterUpdate() Me.DateField.DefaultValue = "#" & Me.DateField & "#" End Sub Private Sub NumericField_AfterUpdate() Me.NumericField.DefaultValue = Me.NumericField End Sub Private Sub TextField_AfterUpdate() Me.TextField.DefaultValue = Chr(34) & Me.TextField & Chr(34) End Sub Check this List ACCESS-L@PEACH.EASE.LSOFT.COM Hope it helps Don |
da read (4014) | ||
| 1 | |||||