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))
>> IF this.Value <> TTOD(table.field)
>> 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