Thanks I get make sure about the dateformat in my base class. In fact I tried it out and it is working great. Also solved my second query about NULL which is of a similar nature, I did a SET NULLDISPLAY.

By the way putting it in the load ie. SET DATE, when the form looses focus and goes onto a totally different type of form the null displays returned so I had to put in both the form base classes SET DATE in activate and reset the SET DATE in deactivate. Now there is only a flicker of the reset that happens between both the forms.

I tried SET DATE in the setup.prg of mine but wouldn't work from there.

>Yes provided that they don't override with DateFormat property. To be sure you could do :
>thisform.SetAll('DateFormat',0)
>Cetin
>
>
>>Okay so I can
>>
>>SET DATE TO dmy
>>
>>in my form.load() and all the textboxes in this form or it's child classes (of the form as well as textboxes, even if in the grid) will show the date as we want it?
>>
>>>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