Access 2007 Date field shows Now instead of Date

[bobdydd]

Hi

Access 2007

I have a check box that has on the "After update" event the following
code:

If Me.chkBuyerPayInvoice = -1 Then
Me.txtBuyerPaidDate = Date
Me.txtBuyerCheckClearDate = Date
End if

But instead of it putting the Date 14/07/2011
It is putting the Now 14/07/2011 21:38:53

I just want the Date

The field is formatted to Short Date and the regional settings are dd/
mm/yyyy (UK)

Grateful for any help

Regards

 

[John W. Vinson]

Hi

Access 2007

I have a check box that has on the "After update" event the following
code:

If Me.chkBuyerPayInvoice = -1 Then
Me.txtBuyerPaidDate = Date
Me.txtBuyerCheckClearDate = Date
End if

But instead of it putting the Date 14/07/2011
It is putting the Now 14/07/2011 21:38:53

I just want the Date

The field is formatted to Short Date and the regional settings are dd/
mm/yyyy (UK)

Grateful for any help

Regards

Is there perhaps a Default Value property, either in the textbox or the table
field to which it is bound? Does the field show blank prior to checking the
checkbox?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[bobdydd]

Hi John

That put me on the right trail.
It is copying the date from an email inbox date field.

Is there any way to truncate it to just the date
without including the time?

Thanks

 

[John W. Vinson]

Hi John

That put me on the right trail.
It is copying the date from an email inbox date field.

Is there any way to truncate it to just the date
without including the time?

Thanks

Sure; set it to Int([datetimefield])
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[bobdydd]

Sure; set it to Int([datetimefield])

Thanks John
That worked perfectly