What I meant was :
I never play with textbox.dateformat
Instead I code :
set date to dmy
set century on
etc
In form.load or in DE.BeforeOpenTables (load nicer to me because I can directly code it in mybase form class)
These and more 'set's are scoped to current datasession. That's why I do it per form (datasession is likely to be private).
So if it's a subclassed textbox or base textbox (provided didn't play with DateFormat property in anyone of them) my dates display correctly (Sparse=.t. would display from base, and when it has focus from subclassed).
Cetin
>Set sparse=.f. and then it looks okay. Recently with your help I was able to solve the format and inputmask problem (I want to avoid sparse as far as possible).
>
>Any suggestions.
>
>>>Hi all
>>>
>>>I have this grid which has a date textbox in it. The Date Text Box has been defined as D/M/Y but as soon as it looses focus the date in the column reverts to M/D/Y, which is confusing here,
>>>
>>>Please advise.
>>
>>Sounds like sparse=.t.
>>However control the date setting at form level (ie:from form.load)
>>Cetin