Re: Getting Date Only



Are you sure the value of the field is "Closed"? If the status field is a
combo, the actual value will probably be numeric.
"CyndyG" <CyndyG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:111DD283-05BF-44A5-9562-0C7DC01766CB@xxxxxxxxxxxxxxxx
> I can not get the date to appear in a field automatically after a certain
> event occurs. Here is the code:
>
> AfterUpdate for strRequestStatus Field
> If Me.strRequestStatus = "Closed" Then
> dteDatedClosed = Date
> End If
>
> I have tried on lost focus,
> I have tried using Date(), have tried setiing the date to short date,or
> formatting to mm/dd/yyyy.
> At one point I clicked in the field the date showed up,but went away when
I
> saved the form.
>
> This is the same code I used in another database using Now() instead with
no
> problem.
>
>
>
>
>


.



Relevant Pages

  • DataList with RadioButtons + Images: How to click on the images to activate the radiobutton?
    ... (sorry for the formatting;)) ... Basically it's filled with a bunch of choices from the database, ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Update form formatting on FLY?
    ... Is it possible to create some code which can automatically update my ... forms formatting? ... I have a small database with a form which is periodically changed. ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: Access crashes after SP3 installed
    ... uninstalling removed all my desktop shortcuts. ... I'm now getting this error after applying SP3 yesterday. ... Every table in my database has more than 10 fields. ... I am personally do not using any type of formatting for a table. ...
    (microsoft.public.access.formscoding)
  • Re: How to convert plain ASCII text file to RTF?
    ... > in his database, so I need to send it again. ... It isn't like formatting really matters because the pimps will ... Provide two PDF files. ...
    (comp.unix.bsd.freebsd.misc)
  • Re: Mailmerge keep formatting from Excel database or...
    ... you should be able to apply the formatting you ... the company-provided cell phones are not all the same ... What if I create a separate field in the database that I ... Attempting to soak up all the knowledge from other generous Word & Excel ...
    (microsoft.public.word.mailmerge.fields)