Actually I meant to use HOUR() MINUTE() and SECOND() to get the time out of the datetime.
>Jim,
>
>I think you mean DTOT() <g>
>
>
>All the best
>
>Peter
>
>
>
>>>Ok tnx But how could I suppress the date inside a form? tnx again
>>
>>If you surpress the date then the nuser cannot enter the date and you have the same problem.
>>
>>To surpress the date you use the TTOT() function to get then time out of the datetime value. Y0u would need to put code in the events of the textbox, in the refresh() you could put ...
>>
>>
>>This.Value = TTOT(SomeTableAlias.DatetimeField)
>>
>>
>>In the LostFocus() you could put ...
>>
>>
>>REPLACE SomeTbaleAlias.DatetimeField WITH TRANSFORM(YEAR(DATE())) + "/" + TRANSFORM(MONTH(DATE())) + "/" + TRANSFORM(DAY(DATE())) + " " + This.Value
>>
>>
>>But using the above code will again present ther same problem I mentioned in the previous message. The date is being forced to today and you lose the TimeIN is on a particular date as is the time out.