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

On Fri, 15 Jul 2011 00:18:43 -0700 (PDT), bobdydd
<(E-Mail Removed)> wrote:

>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/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com

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

On Mon, 18 Jul 2011 14:00:44 -0700 (PDT), bobdydd
<(E-Mail Removed)> wrote:

>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/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com

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

Thanks John
That worked perfectly