Time()

S

Sport

Is there a way to trunkate what the time function sets; I have a field that
is formated as short time, and a button to set it to the current time using
the time funtion. Now if you use the button to get the current time, but
say want to back it up 30 min. When you put the cursor in the field to make
the changes you actually get the long date and have to delete the unwanted
characters, as I am using an input mask and it creates a conflict. I would
like to keep the input mask, so I thought of trying to force the format of
the time fuction. If this does not make any sense please ask for more
information.

thank you,
 
C

Chris Large

Use the format function, in your button code:

Something like

format(Time(),"hh:nn")

hth

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top