>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(...