Using Date Time as Default

[Guest]

I am using MS ACCESS 2003
I have a date field in a table with default set to =Now().
I use that field in a form and a report.

I would like to have the format "yymmdd""-""hhmmss" rather than the general
date time =Now() produces.

Is there an expression I can use as the default to produce the desired format?

Thanks in advance

 

[Joseph Meehan]

I am using MS ACCESS 2003
I have a date field in a table with default set to =Now().
I use that field in a form and a report.

I would like to have the format "yymmdd""-""hhmmss" rather than the
general date time =Now() produces.

Is there an expression I can use as the default to produce the
desired format?

Thanks in advance

Remember that no matter how it looks the actual data of a date-time
field is always stored the same way. Access changes the format as it is
displayed.

Access tables are not really designed to display data or to work with
data. You should be using queries, forms and reports to view and edit your
data and you will want to define the format in the query, form or report,
not in the table.

 

[Steve Schapel]

Shep,

You can use the Format property of the controls on your forms and
reports for this purpose. Setting the Format property of the field in
the table design will propogate the same format through to new forms or
reports based on the table. Just enter this in the Format property...
yymmdd-hhmmss

 

[John Vinson]

I am using MS ACCESS 2003
I have a date field in a table with default set to =Now().
I use that field in a form and a report.

I would like to have the format "yymmdd""-""hhmmss" rather than the general
date time =Now() produces.

Is there an expression I can use as the default to produce the desired format?

Thanks in advance

A Date/Time field is actually *stored* as a double float number, a
count of days and fractions of a day (times) since midnight, December
30, 1899. The format is relevant only for display, and it's not stored
with the value.

You can set the Format properties of the textboxes on the form and
report any way you like. The date/time value stored in the table will
be displayed in accordance.


John W. Vinson[MVP]

 

[Guest]

Thank you, that helped.

Shep,

You can use the Format property of the controls on your forms and
reports for this purpose. Setting the Format property of the field in
the table design will propogate the same format through to new forms or
reports based on the table. Just enter this in the Format property...
yymmdd-hhmmss

 

[Guest]

Thank you, that helped

A Date/Time field is actually *stored* as a double float number, a
count of days and fractions of a day (times) since midnight, December
30, 1899. The format is relevant only for display, and it's not stored
with the value.

You can set the Format properties of the textboxes on the form and
report any way you like. The date/time value stored in the table will
be displayed in accordance.


John W. Vinson[MVP]