Results 1 to 2 of 2

Thread: paste errors

  1. #1
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224

    Unanswered: paste errors

    I have a time field with input mask as short time ie 12:12
    If the time entered is single digit hour eg 01:10 or 09:59 which then become 1:10 or 9:59 I am unable to duplicate the record using the duplicate button on my form. This is because when duplicated it doesnt fit the input mask

    Is there a way to get around this without removing the input mask

    thank you

  2. #2
    Join Date
    Jul 2004
    Posts
    5

    Post

    Not sure how your duplicate button works, but maybe if you use the "Format" comand as part of your code?

    Format(TimeValue,"HH:NN")

    or if you are using Access2002

    FormatDateTime(TimeValue,vbShortTime)


    Good Luck
    D

Posting Permissions

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