Access 2007 Date field shows Now instead of Date

  • Thread starter Thread starter bobdydd
  • Start date Start date
B

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
 
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
Click to expand...

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
 
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
 
Back
Top