<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=515033813-25032003><FONT face=Arial color=#0000ff size=2>That's
just a formatting issue. Copy the following into a module:</FONT></SPAN></DIV>
<DIV><SPAN class=515033813-25032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=515033813-25032003><FONT face=Arial color=#0000ff size=2>Public
Sub TestDate()<BR> Dim d As Date<BR>
Debug.Print d<BR> Debug.Print Format(d, "long
date")<BR> <BR>End Sub<BR></FONT></SPAN></DIV>
<DIV><SPAN class=515033813-25032003><FONT face=Arial color=#0000ff size=2>In the
debug window you will see:</FONT></SPAN></DIV>
<DIV><SPAN class=515033813-25032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=515033813-25032003><FONT face=Arial color=#0000ff
size=2>12:00:00 AM <BR>December 30, 1899<BR></DIV></FONT></SPAN>
<DIV><SPAN class=515033813-25032003><FONT face=Arial color=#0000ff
size=2>HTH,</FONT></SPAN></DIV>
<DIV><SPAN class=515033813-25032003><FONT face=Arial color=#0000ff
size=2>Arthur</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/plain format -->
<P><FONT size=2>"Those who would sacrifice liberty for security deserve
neither."<BR>-- Benjamin Franklin </FONT></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Barbara
Ryan<BR><B>Sent:</B> March 25, 2003 7:52 AM<BR><B>To:</B> Access
List<BR><B>Subject:</B> [AccessD] Problem with Date type
variable<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>I am encountering a problem with date type
variables in Access 97. When I create a date type variable (e.g., "Dim
dtDate as Date") , the variable has a default value of 12:00:00 AM. I
don't remember this happening before.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I recently did a "cleanup" on my PC, removing
software I no longer use. Could I have removed a needed driver(s)?
I ask that question because I am also having a problem with my printer (HP IIP
Plus) not printing lines on reports (which it was doing fine last week).
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Any thoughts?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>Barb Ryan</FONT></DIV></BLOCKQUOTE></BODY></HTML>