SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jan 2005
    Location
    BenBen
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Access 97 help! I am so puzzled

    Hi,
    There is so odd situation. In Access 97, I want to show date in a textbox. In text box property, I usually put control source = Format(Date(),"dd-mmm-yyyy"), it works perfact before, but I do not know by how, it does not work any more. System always give me error like "Function isn't available in the expression". I am so desperated now. Dose anyone know what is wrong??

  2. #2
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try the following code:

    =FormatDateTime(Date(),2)

    Does that work at least?


Bookmarks

Posting Permissions

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