Also, make sure that when you are saving data to it, save it in a Formatted
way, like this:

AdoRst!Date = Format(dtDate, "mm/dd/yyyy")

-----Original Message-----
From: LaFerriere, Patrick M. [mailto:PLaFerriere@T...]
Sent: Thursday, May 17, 2001 1:43 PM
To: professional vb
Subject: [pro_vb] RE: Access Database and date type


The problem was with the ShortDate format in Access. By default the short
date in Access has both the time and date. I needed to set the field mask
like this 
mm/dd/yy and not this: ShortDate 

Thanks again for the suggestions
Patrick LaFerriere
Analyst/Programmer , MCP
Transitions Optical 
xxx.xxx.xxxx  Ext. 2222
PLaFerriere@T...