Access 2007 Date field shows Now instead of 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
 
Ad

Advertisements

J

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
 
B

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
 
J

John W. Vinson

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top