Results 1 to 3 of 3

Thread: Access - date and time in textbox?

Threaded View

  1. #1

    Thread Starter
    Addicted Member Lee_S's Avatar
    Join Date
    Dec 2000
    Location
    New Zealand
    Posts
    250

    Resolved Access - date and time in textbox?

    This is probably simple, but how do i format the date to show date and time in a textbox?

    Unbound textbox on form set to =Now()

    But I want the format "Monday 30 May, 2005, 12:15 pm" if possible. Basically adding Long Date and Medium Time together.

    I could do a seperate textbox for date and time, but then you get a gap between the textboxes, depending on the length of the date. Is there a way to align the time textbox always to be next to the date box?

    cheers
    lee
    Last edited by Lee_S; Jun 7th, 2005 at 01:21 AM.
    Lee Saunders
    Win XP Professional : VB6 Enterprise / VB 2005 Express

    History admires the wise, but it elevates the brave.

Posting Permissions

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



Click Here to Expand Forum to Full Width