Date Re-Formatting unnesessary?

  • Thread starter Thread starter JethroUK©
  • Start date Start date
J

JethroUK©

If a date/time field has a format defined in the main table - is it
nessessary to define it again in the form control?

is it efficient? (Re-Formatting all dates on a form)
 
If a date/time field has a format defined in the main table - is it
nessessary to define it again in the form control?

is it efficient? (Re-Formatting all dates on a form)
Click to expand...

If the field has been added to the form from the Field List tool
button, it will retain whatever formatting is set up in the table
field.
If you then subsequently change the table field formatting, the
existing control format will not change. To get the new formatting,
either change the control formatting or delete that control and re-add
a new one from the Field List tool button.
Remember though, the field format in the table really doesn't matter,
as you should always be entering, viewing, and manipulating your data
through a form, query or report.
 
If a date/time field has a format defined in the main table - is it
nessessary to define it again in the form control?
Click to expand...

Not really. The default format when you create a textbox on a Form
will be the (then current) table format for the field.
is it efficient? (Re-Formatting all dates on a form)
Click to expand...

It's unnecessary if you're not changing it. The control's format
property gets set one way or the other, no point in doing so twice!

John W. Vinson[MVP]
 
Jethro,

To add to Fred's and John's comments... In my experience it is not an
uncommon experience to want the date from the same field to have a
different format in different places, depending on operational
requirements. For example, right now I am working on a database of
sports fixtures. On the form used for the match listing, the match date
is shown as 19-Nov-05 whereas in the header of the report of referee
appointments, the data drawn from the same field is shown as Saturday 19
November.
 
Back
Top