See
Re: Display a date from a datetime? Thread #
965996 Message #
966087>
>I need to make a Time Field look like a Date Field on a Form in a Textbox at run time. This is only required if the user is connected to one database instead of another. Is there a way to do this in code?
>I tryed:
>
>thisform.textbox1.controlsource = "TTOD(vehicle.timedate)"
>and
>thisform.textbox1.controlsource = " =TTOD(vehicle.timedate)"
>
>neither worked, so I tried this in the refresh of the form
>
>if vartype(vehicle.timedate) = "T"
> thisform.textbox1.value = TTOD(vehicle.timedate)
>endif
>
>none worked.
>Any Help???
>
>TIA
>Beth
--sb--