writing a time in VBA

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • 312student
    New Member
    • May 2010
    • 2

    writing a time in VBA

    I am trying to write a time in VBA. I have a text box on an Access form that I want to equal one minute in short time format, but I don't know how to write the code for it. I tried writing me.text22.value = "0:01" but it gives a type error. I already formatted the textbox to have a short time format.

    Please help!
  • dsatino
    Contributor
    • May 2010
    • 393

    #2
    format("0:01"," H:MM")

    your problem is that you're passing text to date formatted text box, hence type error

    Comment

    Working...