Date/Time Issue

[Tony]

Hi All,

I'm experiencing a problem wherein a text box control bound to a Date/Time
field displays only the date, but stores the date & time in the bound field.
Here's what I have:

txtDateInspected - bound to Date Inspected
Date Inspected - Type=Date/Time, Format=mm/dd/yyyy, Property to use=Value

When I run the form and enter a date, the correct format shows in the
control (e.g., "8/21/2003") but on the All Fields page "Thu 8/21/2003 8:00
AM" is displayed. This is not a problem until the form is printed through
Word and the Date Inspected field on the doc shows the date & time. I just
need the time.

Any help that can be offered is appreciated.

Thanks & Ciao,

Tony

 

[Hollis D. Paul]

Any help that can be offered is appreciated.

The trick that is usually used is to not bind the control to the field,
but use the click event of the unbound control to get the full string
from the control, strip off the time portion, and stuff the date
portion into the field. The alternative, is to strip off the time
portion in Word, using a Word macro.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA