On Tue, 8 Mar 2005 00:26:34 -0000, "DL" dl@spoofmail wrote:

Cannot the table field properties, in the table design, also be used?

You can set the Input Mask property of table fields. It's pretty
limited and can be frustrating for the user, though.

Setting the format of a Date/Time field in a table is pretty
pointless, though; the date is NOT stored formatted, it's stored as a
double float number of days since an arbitrary start point. Data
storage and data display *are two separate functions*.


John W. Vinson[MVP]