YOu can turn of whether a VFP textbox displays the seconds, why not the full time. I think it is a little different. But, as you say, I will 'deal' with it.

>I'm guessing that they expected that the user input controls would reflect the data as it is. I don't see that what you're suggesting is really any different than saying that there should be a simple way to set a textbox controlsource to only deal with the 1st (or middle, or whatever) 5 characters of a 15 character field. I doubt it comes up much, and when it does, we just have to improvise.
>
>Alan
>
>>Yep, that's basically what I am going to do. I can't belive there is no way to set a text box to only display/edit the date portion of a date time field. I guess cause VFP has a date type they never thought this was needed.
>>
>>>I doubt you can do it directly. You can put code in the refresh to:
>>>

This.Value = TTOD(Table.field)

>>>and then in the valid, or wherever works best for you,
>>>

>>>Local llOk
>>>llOk = .T.
>>>IF !EMPTY(DTOC(this.Value))   && valid date?
>>>   IF this.Value <> TTOD(table.field)   && changed?
>>>      replace table.field WITH DTOT(this.Value)
>>>   Endif
>>>Else
>>>   llOk = .F.
>>>   MessageBox('Invalid date')
>>>ENDIF
>>>
>>>Return llOk
>>>

>>>
>>>>Does anyone know if it is possible to limit a textbox to only display and allow editing of the date portion of a datatime field?
>>>>
>>>>Thanks, BOb