>the datetime() function refresehes my whole form and does not let me write correctly in the textbox, while im updating every second. But with the time() function, it does not have that problem. So I guess Ill stay with 24 hour clock, but thanks anyways :)
WHAT?
How the function iteself will refresh whole form? Take a look in Cetin's answer, use TTOC(DATETIME(),2).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.