Date/Time Issue

  • Thread starter Thread starter Tony
  • Start date Start date
T

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
 
Any help that can be offered is appreciated.
Click to expand...
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
 
Back
Top