Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Not Displaying (Access 2000)

    I am working on a form for enrtering call center data. One of the fields is automaticlly set to NOW() when the the first field on the form is populated.

    My problem is the field on the form for this value appears blank. If I move to the next record and then return to the record just entrered, the date is displayed. If I move to the filed and use the zoom function, the date is there. When I close the zoom window, the date displays.

    How do I get the date to display without moving to the next record or zooming?

    The field is tied to a field in the recordsource, and is formatted to a General Date format.


    Thanks for any help.
    Richard

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date Not Displaying (Access 2000)

    > One of the fields is automaticlly set to NOW() when the the first field on the form is populated

    How is that done?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Not Displaying (Access 2000)

    On the LostFocus event of the associateID field, I put the following code.

    if isnull(me.txtCallDate) then
    me.CallDate = Now()
    end if
    Richard

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date Not Displaying (Access 2000)

    You don't need code. Just set the Default Value property of the CallDate field in the table or of the CallDate text box on the form to Date() if you want only the date, or to Now() if you want the date + time.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •