Hi John,

I sure hope to be there. Depends on what happens with the deadline for this project (which doesn't appear to be going *anywhere* :) ).

If I use the dbsetprop to change the datetime type to a date, what effect will that have when I send the data back to the Access table? I would think that since it doesn't have just a date type that it would handle it okay, but you never know with Microsoft :).

Thanks!

>Hi Ed, Denise
>
>Denise (see you at the FUG in Jan?), an easy way to do this might be to use DBSETPROP() to change the DataType, for example:
>
>DBSETPROP("datetimefield","FIELD",DataType,"D")
>
>No mess, no fuss.
>
>
>>>I've got this data that's coming from an Access database so the dates are in datetime format.
>>>
>>>I only want to show the date on my form. I found the time to date function and it works beautifully in the command window. I type in ?ttod(fieldname) and it gives me the date and everything's beautiful.
>>>
>>>However, I've got a textbox on the form where I need to do this same thing. I've tried putting the =ttod(fieldname) in the value property of the textbox but no luck. I've tried putting =ttod(fieldname) in the input mask and putting an "R" in the format, but still no luck. Where can I put this function so that I only see the date on my form?
>>>
>>>Thanks!
>>
>>if you use data-bound textbox then TTOD() should be in Textbox.ControlSource. If it's unbound then the place is Textbox.Refresh method: This.Value=TTOD(...